SQL Server 2005 (SSIS Package / Password not saving on datasource
Posted on 2012-03-15
I have a rather simple ssis package. It has two datasources. One local and one remote.
I have Visual Studion 2005 installed on the SQL Server. (Server is 2008 R2) SQL 2005.
I can run the package just fine in Visual Source Safe, but when I deploy the package and run it from inside SQL Server (Job or Manually run the package) I get an error about the remote connection not haveing a password.
I have tried to change the protection level to server storage then saving the package but I get an error The system could not verify that the destination supports secure storage capability.
I have tried Encrypt all with password, but it won't save the password.