-
Transfer a DTS package from one server to another
I want to move a DTS package from one server to a new server.
I know I can do a "Save as" and then redo all the different property settings once on the new server....but is there a way to do a Import/Export through the wizards ?
I tried this method, but was not able to choose a DTS package...only thing I was able to choose was database, tables, views, etc., but no DTS package.
Thanks for your insight
-
There is no wizard for this in sql new, check sqldts.com for script to copy dts packages.
-
Copy DTS packages
You can use the export option. Pick the msdb database. The packages are in the sysdtspackages table. Since this is a system table it will not show up in the drop down list of tables, but you can manually type it in.
-
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|