|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
 |
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How can I transfer the particular DTS package from one SQL Server to another? Answer: 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. |