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 |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2009-07-17 : 09:37:05
|
| I have dozens of packages I've created on a test machine which manipulate database objects that work fine. When I move them to another machine, I get login errors. After some investigating, I have found that the OLEDB connection manager objects in my SSIS package does not retain the password.How can I get the packages to retain the password when I move them to another machine without having to manually re-entering them each time? |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-07-22 : 10:57:28
|
| You can use package configuration to store your connection string. |
 |
|
|
|
|
|
Connection passwords missing when packages moved