create a deploymentmanifest in ssis
Hi All,
I have 185 packages. All are password protected. When I tried to build it it's opening each packages and asking for the password.
How can I do the build without entering the password for all 185 packages.
Thank you
Srinisrinivas
September 15th, 2011 1:11pm
I guess you want to design/modify the packages.
If the package is encrypted with option EncryptAllWithPassword then there is no way opening it.
If the package protection level is EncryptSensitiveWithPassword then just ignore the password prompt and then set the connection string(s) for the package to work.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2011 1:49pm
Thanks for the reply.
I guess there is a way to ignore the password.
Thank you
Srinisrinivas
September 15th, 2011 2:08pm
You are welcome.
Please mark my reply as an answer then.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2011 2:26pm