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 |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2004-10-06 : 19:25:06
|
Hey guys...We have to move our dbs off one server and onto another.The server names will not be the same. Any suggestions for rebuilding the DTS packages with the new server namewithout editing every package?  |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-06 : 23:17:18
|
| Save them as VB files. Do a find/replace. Add them back into SQL Server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
DTS - New Server