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