In this example, we will first create the SSIS Catalog. Then, we will deploy the SSIS project that we created in the previous examples. For this example, you need to have SSIS 2012 or higher versions installed, because SSIS Catalog is not available for earlier versions of SSIS. Perform the following steps to deploy an SSIS project:
Open SQL Server Management Studio (SSMS) and connect to the database engine.
In the object explorer, expand the server name and then right-click on the Integration Services Catalogs and then click on Create Catalog. In the Create Catalog dialog box, just set a password and click on OK.
SSISDB catalog will be added under the Integration Services Catalogs node in SSMS. The SSISDB name cannot be changed for this version as well as the earlier versions of SSIS.
Go to SSDT and right-click on the Project file in Solution Explorer and select Deploy.
Now, the Integration Services Deployment Wizard will appear. In the Select Source...