I’ve wrote a blog about SSIS – Enable Package Configuration for Deployment.

It showed you how you can set up the package configuration files on your development PC and enabled it in BIDs.

If you are a release coordinator, you would follow the same step to create the configuration files on the server.

In this blog, I’ll show you the last simple step to use the package configuration files when you create a SQL job for your SSIS package.

When you are setting up the SQL job for your SSIS package, go to the Configuration tab.

Click the Add button to add the configuration files.

Naming convention:

1) All package configuration files have extension of .DTSConfig.

2) Each connection in your SSIS package should have a correspondent configuration file. For example, connection IDS should have a configuration file called IDS.DTSConfig.