April 16, 2003 at 11:55 pm
How is a DTS Package copied to another SQL Server?
Why do I want to do this? The DTS Package was developed on a development server and I want to move it to the production server.
April 17, 2003 at 4:00 am
You could save the package as a "Structured Storage File". (check BOL for "Structured Storage")
April 17, 2003 at 8:26 am
open the dts in development server
clik the menu 'package','save as' and select the
SQL server you want to copy.
Regards
Joseph
April 17, 2003 at 8:32 am
Is there anyway to move several DTS packages at once? Rather than opening each one and doing a 'save as' to the new server?
May 8, 2003 at 2:57 am
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy