Hi, all.

This is a basic SSIS question.

IA co-worker of mine created several SSIS packages in Business Intelligence Development Studio. I have to use those packages to move data from an old database to a new one. (Creating new packages isn't an option.)

My problem:

A coworker created some SSIS packages. They the protection level "EncryptSensitiveWithUserKey." I changed the package protection level to "DontSaveSensitive", so those packages aren't encrypted specifically to her, but I get a new error message:

It says that a null password was given.

My question:

I have no idea where the password is supposed to be. If they have to be in a configuration file, can you tell me exactly where it is, with Syntax for including it?

Please note that I am transferring data from a SQL Server database to an Oracle database.

 When you save the package as "DontSaveSensitive", that means you are not saving the passwords for the connections used in the package. How do you execute the package? From a job, manually? If you do it manually, you could set the password for the connections prior to execution. Another option would be to change the package, so it saves the password in the connections, reather than DontSaveSensitive.