February 22, 2016 at 1:48 pm
Hi,
I posted this in here b/c I didn't see an SSIS forum for SQL 2008. Here's my problem. I inherited solution that has an dtsx in it. It has six connection mgrs that had old credential info. I updated all connection mgrs; tested their connectivity and successfully got all errors to dissapear, I proceeded to save the solution and close BIDS. A while later i opened the solution and I was very dissappointed to see that all my DFT's had red x bullets in them. Somehow the connection managers were not working. Why would this happen? Is there a setting that prevents this information from remaining in the solution? has this happened to anyone else?
Any guidance will be greatly appreciated.
J.
February 22, 2016 at 2:36 pm
Security.
Go into the package properties and look for the Security section. The default is 'EncryptSensitiveWithUserKey' which lets YOU connect nicely. If you want to retain SQL account connections you need to password protect the package.
Change the security to 'EncryptSensitiveWithPassword' and give the package a password. After doing that you should be able to keep the connection information in the package.
Of course that means storing the package password somewhere safe.
February 22, 2016 at 3:31 pm
I added the property and password and now my DFT's are running successfully. Thanks JustMarie.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply