dbTalk Databases Forums  

Automate saving DTS to files

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


Discuss Automate saving DTS to files in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andre
 
Posts: n/a

Default Automate saving DTS to files - 08-12-2003 , 01:45 PM






Does anyone know of code that automates the process of
saving your dts packages to files. So say I have 50 dts
packages that I want to save to a file. I dont want to
manually open each one up and save. I want to have some
code that will take each package and save it to a file. I
hope that is clear enough. I have been searching
everywhere. You guys are my last hope. Thanks.

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Automate saving DTS to files - 08-12-2003 , 04:14 PM






In article <0d3a01c36101$ed921020$a001280a (AT) phx (DOT) gbl>, Andre
<andrec75 (AT) yahoo (DOT) com> writes
Quote:
Does anyone know of code that automates the process of
saving your dts packages to files. So say I have 50 dts
packages that I want to save to a file. I dont want to
manually open each one up and save. I want to have some
code that will take each package and save it to a file. I
hope that is clear enough. I have been searching
everywhere. You guys are my last hope. Thanks.

DTSBackup 2000
http://www.sqldts.com/default.aspx?6,105,242,0,1

Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1

You could also use DTSRUN with /S and /F. Lookup up DTSRUN in Books
Online for the full set of parameters, but if you supply both server
details and file details it loads from the server and saves to a file.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.