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 |
|
vikram1
Starting Member
13 Posts |
 Posted - 2006-03-13 : 02:43:36
|
| hi, i am trying to transfer a package from one server to another which i can do correctly the only problem being that i have to change the refernces again and again whenever i transfer one package from one server to another. can anyone tell me a way to automatically update the connections while transfer of dts package???????? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-13 : 02:50:29
|
| I have changed some DTS packages to stored procs becuase of issues like this (and others).SQL 2000 DTS has a feature called Dynamic Properties which does pretty much what you are asking for. Here is a good article on how to use it: http://www.databasejournal.com/features/mssql/article.php/3073161sqldts.com is also another good resource for all things DTS.-ec |
 |
|
|
|
|
|
package transfer problem