April 15, 2009 at 1:36 pm
I need to store my ConnectionString for the ConnectionManager using the XML Configuration.I am using SQL Authentication. When I select the ConnectionString Property while configuring the properties for XML Configuration.The resulting dtsconfig file doesn't contain the password
ForEg: Below is what my config file contains.
It doesn't have the Password attribute below.Any help regarding this is much appreciated.
April 19, 2009 at 7:42 pm
You might want to take a look at this other posting in the forums and view the best practice articles that I included along with the video for reference for SSIS configurations.
Database Connectionstring as a variable
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 20, 2009 at 11:30 am
Check your 'Save Sensitive' package property. You'll want to read up on this. SSIS can be very difficult if you don't fully understand how it wants to utilize sensitive information like usernames and passwords.
Ben Sullins
bensullins.com
Beer is my primary key...
April 23, 2009 at 10:59 am
There is no separate attribute for password in connection string. Include the password in connection string after username.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply