Friday, March 03, 2006 3:58 PM
I want to modify a package stored on the server from my client machine, and everything goes great.
The only problem I get is that when I try to run it by double-clicking it I have to re-write the password in the connection string, i.e. "pwd=asdasd", because it is not saved by the package itself even though the checkbox in the Connection Manager tab (in the SSIS Designer) is checked. What can I do to save it automatically??
Friday, March 03, 2006 4:41 PMModerator
Check the ProtectionLevel property of your package. I'm guessing that it is set to "Don't Dave Sensitive". This means that passwords won't be saved in teh package.
Check BOL for ProtectionLevel to understand what other options are available to you. Its also covered here: http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx about halfway down.
Monday, March 06, 2006 2:14 PM
it was like you wrote...