Script To Export All DTS Packages ON IS To File Sy

Question

Is there a script that will export all DTS packages on an Integration Services Server to one file system path (ie: C:\DTSPackages)? Currently, the task of right clicking, selecting export, choosing the file system seems somewhat redundant if a script exists, yet all I've found are scripts to show what packages exist (unimportant).

Thanks.

Answer 1

You could use the DTUTIL utility to script movement of packages:

http://msdn.microsoft.com/en-us/library/ms162820.aspx

Here is an example of moving from SQL to File:

http://www.bimonkey.com/2010/01/ssis-command-line-utilities-part-1-dtutil/

Here are some scripts to enumerate packages in MSDB:

http://blog.hoegaerden.be/2010/01/10/list-all-ssis-packages-deployed-on-your-integration-server/

http://gallery.technet.microsoft.com/scriptcenter/List-all-SSIS-packages-3b247394

Finally, there's a SQL query you can run to generate the dtutil calls which you can then pipe into a batch file. See ssis package extract from msdb

If you want some help sticking it all together let me know. I don't make much effort here unless I know the OP is engaged.