Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rlopez
Starting Member
18 Posts |
 Posted - 2007-01-28 : 02:31:00
|
| I am having a terrible problem with an SSIS Package. I created a connection in the Connection Manager and the option "Use a specific user name and password" is selected. I enter the ID and PW and make sure “Blank password” is not checked and “Allow saving of password” is set, but after I test the connection and it succeeds the password is no longer remembered. Has anyone had a similar problem. This is frustrating. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-28 : 13:49:00
|
| Packages don't save passwords by default.Have a look at the package properties and see what it says about saving sensitive data.I usually put he password in a config file/tableseehttp://www.nigelrivett.net/DTS/SSISConfigurationFile.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rlopez
Starting Member
18 Posts |
Posted - 2007-01-28 : 15:53:54
|
| Thanks, but I am unclear on one part. When I enter the password in the XML file where exectly do I place the password?[Password]" ValueType="String"> |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-28 : 23:10:48
|
| Afer that there should be <ConfiguredValue></ConfiguredValue>Type the password in theree.g.<ConfiguredValue>mypassword</ConfiguredValue>==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Connection not remembering password