sql-serverdts

Is there a way to Copy SQL Server 2000 DTS package and deploy it in another server?

I am trying to copy a database from one server to another in id different location, including all the schema, data, DTS Package, and Scheduled Jobs. I used Redgate's SQL Packager to pack the schema and data.But I am having trouble in packing the DTS Package (which is a very complex one) in simpler way.

Solution

  • I don't have an SQL2000 at hand right now, but I remember that you can simply open the DTS, click File \ Save As... and then save as an DTS file and that would be able to upload the DTS on another server.