Jeff Maass Blog

My momma always said share.

DTS Script out - SQL Server 2000

My preferred method of persisting a DTS package is by saving it to the server and backing up MSDB. At one of my employers, I found many filepaths and other should be variables hardcoded in. Not one week passed before someone said, what’s making this file? To find the creator of the file, I needed a way to GREP their DTS packages. I found this neat article on SQL Server Central. http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1613.

I run it as a .vbs file, and start an instance of it for every server, using a quick and easy batch file such as:
“\Fileserver-4\DTS\Script Out DTS Packages-CmdArgs.vbs” /server:SQLSVR2 /backupfolder:”\Fileserver\DTS”

“\Fileserver-4\DTS\Script Out DTS Packages-CmdArgs.vbs” /server:SQLSVR2 /backupfolder:”\Fileserver\DTS”

One possible use is for easy change control via a text file diffing.