- In SSDT connect to source db and export the ssis package to some folder on the workstation.
- On the generated .ispac file doulbe click.
- Now the Integration Services Deployment wizard will start.
- Click Next and verify the selected ispac file. So are doing deployment from Project deployment file.
- On clicking next it will ask for the destination server and path.
- Click Next and then click on deploy.