Time for action – deploying an SSIS project

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:

  1. Open SQL Server Management Studio (SSMS) and connect to the database engine.
  2. 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.
  3. SSISDB catalog will be added under the Integration Services Catalogs node in SSMS. The SSISDB ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial