We have quite a few SSIS packages on SQL Server 2012 deployed to SSISDB, you can right-click on a project and select 'Export' saved as an *ispac file, however, is there a script to Export All Projects to *.ispac? A script that will loop through all projects and export the *.ispac files to a directory?

Much appreciated.



You can find Import/Export folders and projects from/to local file system to/from SSIS catalog using PowerShell on TechNet and download CatalogMigration file

I hope this will help you

  • Thank you, we will give this a shot, once time is permitted. – Dennis M. Oct 26 '18 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.