Copy SSIS  packages
If we need to export a package from MSDB into the file system we can do it using the from MSDB onto the file system all at once without doing one at a time...Is there a smart way to achieve this ? SQL Management Studio...However, if we need to export VARIOUS (abt 200 SSIS packages) the SSIS packages available
October 21st, 2012 10:47am

Check this thread for simple and efficient solution for copying packages from MSDB into File System: DTUTIL Utility to Copy / Delete SSIS Deployed in MSDB to File System
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2012 11:52am

Hi You can use dtutil commands to copy a single package from MSDB to FIle System dtutil /SQL srcPackage /COPY FILE;c:\myTestPackages\mynewpackage.dtsx
October 22nd, 2012 2:11am

there is no short cut for this..... you have to move alll packages one by one.. check the Kingxxx1 and irusul's link and example.. --Let us TRY this | My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2012 3:02am

If you have a who bunch of packages then you can use little bit of scripting.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
October 22nd, 2012 4:32am

If you have a whole bunch of packages then you can use little bit of scripting. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2012 4:32am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics