Export SSIS Package

  • Open up SSMS -> Integration Services Catalogs -> SSISDB -> Projects -> Export
  • This should create a .ispac file.

Import SSIS Package

Copy over the .ispac file to new server.

  • Double click on the .ispac file to start the Integration Service Deployment Wizard.
  • Select “Project deployment file” and set the “Path” to the .ispac file.
  • Select “Server name” and “Path”
Last modified: July 16, 2021

Author

Comments

Write a Reply or Comment