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”