Integration Services Catalogs — 101

Simple tutorial to explain how to create, import and export .dtsx packages

SSMS (SQL Server Management Studio) is an amazing SQL client which offers plenty of features for developers.

One such feature is integrating SSDT (SSIS) packages in SQL Server.

How to import or add SSIS / SSDT (.dtsx) files to SQL Server ?

Step 1:

Expand SSMS, navigate to Integration Services Catalog

Right click and choose Create Catalog.

Make sure the check boxes are checked and enter a password. If password is not complicated SSMS will not let you create the catalog.

Integration Services Catalog Creation

Step 2 : Importing SSIS / SSDT (.dtsx) packages into Integration Services Catalog.

Navigate to SSISDB

Right click and choose Create Folder

Enter Folder Name (without spaces)

Click OK

Step 3 :

Navigate to the folder which was just created (Main_Project_V2010) and right click on Projects