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 |
|
kjmraohyd
Starting Member
34 Posts |
 Posted - 2006-06-19 : 08:10:52
|
| I have couple of DTS Packages saved as Structured Storage Files. Is there a way (automated procedure) to change servername,username name nad password in all participating SQL Connections?I need to transfer these packages from one location to another location. This is in SQL 2000 environmentTIAJaganmohan Rao |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-19 : 08:21:55
|
| Have a look at the dynamic properties task.If you don't want to change the package you can create a loader which will change the values before it is run.I usually add an activex script to the pacjage which runs first and sets all the values from parametershttp://www.nigelrivett.net/DTS/SetDTSRunTimeValues.htmlYou can do a similar thing in VB between the load and run.==========================================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. |
 |
|
|
|
|
|
Login Credentials for DTS