December 20, 2010 at 12:18 pm
By "my conection doesn´t let me to save my password." I assume you mean that you are not running the SSIS package as your domain user?
If that is true then the problem is that the information is encrypted within the package with your user as the key and cannot be decrypted by the user calling the package.
You can change the package protection level to "Encrypt sensitive with password" and set a password on the package that must be included when the package is run.
Or you can can store the connection strings in an encrypted format and decrypt them in a script task.
I'm sure there are others but those were the two off the top of my head.
CEWII
December 20, 2010 at 1:40 pm
TY, the solution was to put them password =D. So I used the ENCRYPTSENSITIVEWITHPASSWORD.
Now I don't know how to run my package encrypted in a SQL Agent Job =S
December 20, 2010 at 1:57 pm
Per books online there should be a spot to enter it when you go to the configurations tab. I am verifying on a SQL 2008 box.
It asks when I have a package that contains encrypted information..
CEWII
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply