Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Why can't the password be saved??

Answered Why can't the password be saved??

  • Friday, March 03, 2006 3:58 PM
     
     
    Sign In to Vote
    0

    Hi!

    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??

    Thanks

     

All Replies

  • Friday, March 03, 2006 4:41 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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.

    -Jamie

     

     
  • Monday, March 06, 2006 2:14 PM
     
     
    Sign In to Vote
    0

    it was like you wrote...

    thank you