Groups | Blog | Home
all groups > sql server dts > august 2003 >

sql server dts : Automate saving DTS to files



Andre
8/12/2003 11:45:40 AM
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
Darren Green
8/12/2003 10:14:50 PM
In article <0d3a01c36101$ed921020$a001280a@phx.gbl>, Andre
<andrec75@yahoo.com> writes
[quoted text, click to view]


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

AddThis Social Bookmark Button