Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I transfer the particular DTS package from one SQL Server to another?

April 26, 2017DTS package particular SQL Server transfer

0

Posted

How can I transfer the particular DTS package from one SQL Server to another?

1 Answer

0

Posted

There are two ways to move DTS package: 1. Save DTS package as file on the disk, then copy this file on the target SQL Server and load this DTS package on the target machine. 2. Run DTS Export Wizard, and transfer this select statement: SELECT * FROM sysdtspackages WHERE name = ‘DTSPackageName’ from the msdb database on the source server to the msdb database on the destination server to transfer the DTSPackageName package.