Saving Dozens and Dozens of DTS packages to file (i.e BACKUP DTS P

#1

Is there a way to script this? Such as looping through a collection and save
to file? We have dozens and dozens of DTS packages on a server and I see no
way to back them up except to open each one manually and save to file. Please
tell me that there is another way

Thank you,
--
Brad Ashforth

#2

Try this,

http://www.sqldts.com/default.aspx?242

"Brad Ashforth" wrote:

Quote:

Is there a way to script this? Such as looping through a collection and save
to file? We have dozens and dozens of DTS packages on a server and I see no
way to back them up except to open each one manually and save to file. Please
tell me that there is another way

Thank you,
--
Brad Ashforth

#3

I will download and try. Thank you!
--
Brad Ashforth

"Dave" wrote:

Quote:

Try this,

http://www.sqldts.com/default.aspx?242

"Brad Ashforth" wrote:

Is there a way to script this? Such as looping through a collection and save
to file? We have dozens and dozens of DTS packages on a server and I see no
way to back them up except to open each one manually and save to file. Please
tell me that there is another way

Thank you,
--
Brad Ashforth

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

Saving Dozens and Dozens of DTS packages to file (i.e BACKUP DTS P

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

Saving Dozens and Dozens of DTS packages to file (i.e BACKUP DTS P - 11-03-2005 , 08:39 AM

RE: Saving Dozens and Dozens of DTS packages to file (i.e BACKUP DTS P - 11-03-2005 , 09:11 AM

RE: Saving Dozens and Dozens of DTS packages to file (i.e BACKUP D - 11-03-2005 , 09:39 AM