How can I transfer DTS packages from one SQL 7 server to another?

A. Three choices :-

1. Use the DTS transfer wizard. Set msdb as the source and destination databases and "select * from sysdtspackages" on the source.

2. Save each DTS package as a file. Copy the .dts files created to the target machine. From EM, right click Data Transformation Packages and choose all tasks Open Package for each package.

3. Open them in the package designer - choose save as, and save them to the other server.

Option 1 is the quickest for lots of packages

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.