Is there an easy way to copy the SQL Server 2000 DTS package and deploy it to another server?

Question

I am trying to copy a database from one server to another in another place, including the whole schema, data, DTS package and scheduled tasks. I used Redgates SQL Packager to package schema and data. But I am having trouble packing the DTS package (which is very complex) in a simpler way. Please advice!

Answer 1

I don’t have SQL2000 right now, but I remember that you can just open DTS, click File \ Save As ... and then save as a DTS file, and you can load the DTS on another server.

Answer 2

SQLDTS " , msdb.

DTSBackup 2000 DTS DTS

, , - DTS...

Answer 3

, script DTS msdb.dbo.sysdtspackages BCP. , out - - :

bcp "select top 1 from msdb.dbo.sysdtspackages where name = '~your_package_name~' order by createdate desc" queryout c:\temp\dts.bak -n -S ~source_server_name~ -E

DTS BCP ( -P ~password~ -U ~username~ -E, SQL).

:

bcp msdb.dbo.sysdtspackages in c:\temp\dts.bak -S ~target_server~ -E

, , , . , .

Answer 4

. . DTS DTS, . .

DTS 2000 , DTS 2000 .

Answer 5

DTS can be easily deployed with VB Script. I used it personally about 3-4 years ago. Check this:

http://cyrilbeschi.blogspot.com/2012/03/deploying-dts-packages-in-sql-server.html

It also contains sample code.