How to copy SqlServer 2000 DTS packages between servers
May 18th, 2007 by Onyrix 644 Views | 
Email This Post
| 
Print This Post
(2 votes, average: 5 out of 5)
Loading ...- on the destination server create a new DTS Package (yes to transfer DTS you have to make a new DTS)
- create 2 different Microsoft OLE DB Provider for SQL Server connections (a source one and a destination one)
- select the source and then add a Transform Data Task connecting to the destination connection
- do not open the DataPump task properties yet, but open Disconnected Edit from the package menu
- navigate to your DataPump task and set the SourceObjectName and DestinationObjectName properties to [msdb].[dbo].[sysdtspackages]
- open the DataPump task properties and go to the Transformations tab to allow the transformations to auto-generate
- close properties and execute the package
- done
del.icio.us
Digg
Furl
Reddit
Technorati
Stumbleupon