March 6, 2012 at 7:38 am
I am trying to adjust an SSIS package. I have the login and password saved. I enter the password once and I am able to preview everything in the OLE DB tasks. However, whenever I run the package I get the error in the attachment which says that it can't acquire a connection through the connection manager. I don't know what's going on when it seems the password is saved and I'm not receiving any errors.
March 7, 2012 at 12:29 am
What is the protection level of the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 7, 2012 at 4:08 am
Hi,
Change the package protection level in properties window to 'Encrypt all with user key' and check it.
March 7, 2012 at 4:38 am
YADAVAKARAN (3/7/2012)
Hi,Change the package protection level in properties window to 'Encrypt all with user key' and check it.
That will introduce another series of issues, the most important one is having problems when scheduling the package on the server.
It's better to use package configurations and store the sensitive information in a configuration.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 5:11 am
I didn't change the security level of the package. I shouldn't have to as I was just adding some tasks to the package. What I found on the web and ended up doing was removing the config file, running the package and reinstituing the config file and it ran fine.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply