Groups | Blog | Home
all groups > sql server dts > october 2004 >

sql server dts : Moving DTS packages between different environments



ReportFAQGuy
10/7/2004 9:15:10 AM
Hi
Whats the best way to move DTS packages between diff env. We have
approximately 28 to 30 DTS packages. Every time we move it is difficult to
open each and save as on a different server. Is there a script kind of thing
for them. I tried the export option, but it just seems to generate a list of
names of all the packages.
Even with .dts files(or one .dts file having all dts packages) we still have
to open the file and save as SQL Server package.
Is there any easy way to instal all of them at once.
Any help would be appreciated.

Thanks
Sue Hoegemeier
10/8/2004 8:26:37 AM
You can find other methods explained at:
http://www.sqldts.com/default.aspx?204

-Sue

On Thu, 7 Oct 2004 09:15:10 -0700, ReportFAQGuy
[quoted text, click to view]
AddThis Social Bookmark Button