Deploy SSIS to SQL Server

Copy Deployment File to SQL Server

File	Type	Note
MyPackage.dtsx	Integration Services Package
MyPackage.SSISDeploymentManifest	Integration Services Deployment Manifest	Double click to launch Package Installation Wizard
MyPackageInterfaceConfig.xml	XML Configuration Document

Select “SQL Server deployment” and check “Validate packages after installation”

Enter “Server name”, Use Windows Authentication, and “Package path”, check “Rely on server storage for encryption”.

Note: For custom Package path folder, need to create custom folder in SSMS Integration Service first.

Select Installation Folder

D:\Program Files (x86)\Microsoft SQL Server\150\DTS\Packages\MyPackage

Sources:

https://docs.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver15