Open up SSMS -> Connect Integration Services… (Administration mode)

Expand the “Stored Packages” folder -> MSDB folder -> right click and select “Import Package”

Package location: File System

Package path: C:\Deployment\MyPackage.dtsx

Package name: MyPackage

Protection level: Keep protection level of the original package

Note: If package already exist in the MSDB, will get a prompt asking you to replace the existing one.

Note: Make sure you open up SSMS in Administration mode (right click “Run as administrator”)

Note: You can also deploy the SSIS package via “Integration Services Deployment Manifest” file (recommended method).

Last modified: November 30, 2023



Write a Reply or Comment