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 |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2005-05-25 : 15:20:18
|
| I have a number of packages that I need to move from one server to another. However, I also need to add owner and user passwords to each package. I am trying to find out if I can do this from the back end by select the records (DTS packages) and inserting them into the destination servers' system table. For adding the passwords, would I be able to run an update on the system table for the two fields?Any info on this would be appreciated.Thanks |
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2005-05-25 : 17:16:27
|
| I found where the packages are stored. In the systemdtspackages table in the msdb database. Does anyone know where the owner and user passwords are stored for these dts packages and if it is possible to update those fields?Thanks |
 |
|
|
|
|
|
What system table stores DTS packages