Home > SSIS Best Practices > SSIS – Package Configuration File

SSIS – Package Configuration File

To avoid hard-coding the login credentials, we can enable package configurations.

From menu SSIS – Package Configurations, check “Enable package configurations”, click Add. From the Package Configuration Wizard, keep default of XML as file type, then browse to the file path where the config file is located.

A typical config file will look like this. \\Svrname\SQL_SHARE\SSIS\CONFIG_FILES\ConnName1.dtsConfig

<?xml version="1.0" ?>

<DTSConfiguration>

<DTSConfigurationHeading>

<DTSConfigurationFileInfo GeneratedBy="AD-ENT\connorbp" GeneratedFromPackageName="Load_OAS_Data" GeneratedFromPackageID="{13A93147-DE76-488C-A901-4D227A161AD5}" GeneratedDate="7/24/2008 10:10:40 AM" />

</DTSConfigurationHeading>

<Configuration ConfiguredType="Property" Path="\Package.Connections[ConnName1].Properties[Password]" ValueType="String">

<ConfiguredValue>myPassword109</ConfiguredValue>

</Configuration>

<Configuration ConfiguredType="Property" Path="\Package.Connections[ConnName1].Properties[UserName]" ValueType="String">

<ConfiguredValue>myUsername</ConfiguredValue>

</Configuration>

</DTSConfiguration>

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

%d bloggers like this: