Home > SSIS Best Practices > SSIS – Add Configuration Files for Deployment

SSIS – Add Configuration Files for Deployment

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. 

image

Categories: SSIS Best Practices

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: