Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transfer my DTS Packages from one server to another

Status
Not open for further replies.

ashab02

Programmer
Jun 28, 2005
87
GB
Hello
I have recently built a new more powerful server and I would like now to migrate my DTS Packages and JOBS from the old server to the newly created server.

My new server will contain the same data as the old server.
What I would like is to move the packages and also once the packages have been moved I want them to reference the new server within the packages connections?
I have managed to move some packages but they all still reference the old server connection.

Is there a way of doing this?

 
Forgot to mention. The server I am using are both SQL Server 2000.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top