This project is read-only.

password package param doesn't work

Jul 14, 2010 at 9:24 PM

got the package connections encrypted and protected by a password. 

when I call DTLoggedExec with /Password:"mypassword" I get 

Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information.

Am I doing something wrong?

Thanks,

Nic

Jul 14, 2010 at 9:28 PM

Everything seems correct, I'll check ASAP (hopefully in this weekend or in the next week)

Thanks for the feedback!

Jul 28, 2010 at 8:04 AM
Hi nicchidu to decrypt a package encrypted content you have to use the Decrypt option. The Password option is used to set the password when loading Packages from MSDB database using SQL Authentication.