SSIS: Create SSIS Catalog and deploy SSIS Package

This post will focus on how to deploy your dtsx package to SSMS and how you can execute the project from there.

First of all you need to ensure you have already created the SSISDB catalog.

Go to the object explorer and see if you can find a folder under Integration Services Catalogs. If not, simply right click on the mentioned folder and click on Create Catalog.

After having created the SSISDB catalog right click on it and select Create Folder and give it an appropriate name. Open the toggle and you should find 2 more folders (Projects & Enviornments) assigned to it.

Now you can either right click on Projects and import the dtsx file from SSMS or deploy the project from Visual Studio (SQL Server Data Tools). I will go for the latter.

OK, so go to your SSIS project in SSDT and right click in the solution explorer on the top folder and click Deploy.

Select server and for the path, the SSISDB folder we just created.

Click through and once you reached the Review part simply click the Deploy button.

Now should you see your dtsx package in SSMS under the Projects folder.

The package is now ready to be executed on demand. All you need to do is right click on the dtsx file and click Execute

Please check the video above to get a more precise picture.