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).
Comments