I've deployed an SSIS project using the "SA" account to my SQL Server. When I run a package from the SQL Server I am getting the error saying I need to use Integrated Authentication. I corrected the problem in Visual Studio (I changed it to use Windows Authentication) and the packages work fine there. When I redeploy them to my SQL Server, the authentication method didn't change. It won't even let me delete the packages or the project on SQL Server giving me the message that I can't delete using SQL Server authentication. How am I supposed to update the authentication method?
I am finding SSIS so problematic that I'm considering just replacing my data transfer packages with a C# program.
I had to shut down SQL Server Management Studio and then open it using Windows Authentication instead of SQL Authentication. All works now.