Copy Deployment File to SQL Server

MyPackage.dtsxIntegration Services Package
MyPackage.SSISDeploymentManifest Integration Services Deployment ManifestDouble click to launch Package Installation Wizard
MyPackageInterfaceConfig.xmlXML 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


Last modified: July 16, 2021



Write a Reply or Comment