Tuesday, January 14, 2014

SSIS 2012 - Package Configurations

When I started working on SSIS 2012 using SQL Server Data Tools (SSDT), I noticed that SSIS package configuration option was missing. It was available in previous version of SSIS under Control Flow. We could see package configuration by right click on Control Flow surface area. Unfortunately, that option is missing now.

So I am writing this blog to provide help in case you are running into the same issue. I will explain SSIS 2012 Package Configuration in case you are wondering how to implement Package Configuration in SSIS 2012. 

PROBLEM: Package Configuration option is missing as shown in below screenshot:

Here is what MSDN describes: Create Package Configuration. Unfortunately, I could not find “Package Configuration” option there as well. However, I got a hint from the Notes on the same MSDN link which says:
You can also access the Package Configuration Organizer, by clicking the ellipsis button next to the Configuration property. The Configuration property appears in the properties window for the package.

Follow these steps to create a package configuration:

1.      In SQL Server Data Tools (SSDT), open the Integration Services project.
2.      In Solution Explorer, double-click the package to open it.
3.      To open Package Configuration Organizer, click on the ellipse button next to the Configurations property.

4.      In the Package Configuration Organizer dialog box, select Enable package configurations, and then click Add button.

5.      On the welcome page of the Package Configuration Wizard page, click Next button.
6.      On the Select Configuration Type page, specify the configuration type, and then set the properties that are relevant to the configuration type.
I am using “XML configuration file” in Configuration type. Now specify configuration file path in configuration. Click Next button.

7.      On the Select Properties to Export page, select the properties of package objects to include in the configuration. If the configuration type supports only one property, the title of this wizard page is Select Target Property.

Only the XML Configuration File and SQL Server configuration types support including multiple properties in a configuration.

8.      On the Completing the Wizard page, type the name of the configuration, and then click Finish.

9.      View the configuration in the Package Configuration Organizer dialog box and click Close button.

I hope this post is helpful!