Moving DTS packages between different environments

#1

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
ReportFAQGuy

#2

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
<ReportFAQGuy (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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
ReportFAQGuy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Moving DTS packages between different environments

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Moving DTS packages between different environments - 10-07-2004 , 11:15 AM

Re: Moving DTS packages between different environments - 10-08-2004 , 09:26 AM