Sunday, 24 January 2016

SSIS - Configuring Integration Service Catalog

Introduction
Integration service catalog is the new feature of SQL Server started from SQL Server 2012. It is the easy way to deploy the Project. This article is dedicated to the SSIS Developer of 2008 who are now working on SSIS 2012 or 2014. Hope it will be interesting.

How we DO That

Step – 1 [ We have a Package with Project Level Parameters ]




The Project level parameters are described bellow

Name
Data Type
Value
pFlatFileSource
String
E:\ClassSSIS\FlatFile\StudentDetails.txt
pSQLServerName
String
JOYDEEP-LAPTOP\JOYDEEPSQL12
pSQLDBName
String
PracticeDB

Step – 2 [ Use of Project Level Parameters in the Package ]

We used the project level parameters in the Connection String Property of box Flat File Connection manager and OLEDB Destination Connection Manager.





Step – 3 [ Configuring the Integration Service Catalog ]

Integration Service Catalog à Right Click à Create Catalog …





Step – 4 [ Now Deploy the SSIS Project ]

First compile the Project and the deploy it.
Right Click the Project Solution  à Deploy



Here we choose the SQL Server name and Integration Service Catalog Path with Sub Folder.

Step – 5 [ Configuring the Environments ]

Now we have to understand the Environment



It is telling us where we want to run the SSIS package. For example the Development, QA or Production Environment.
Our package have some package level variable and the value of those variable is different depends on the environment.



Step – 6 [ Configure the Project with Specified Environment that we Configure ]

Project à Right Click à Configure






Hope you like it.


Posted by: MR. JOYDEEP DAS