An error occurred while setting the value of property “Initial Catalog”

Standard

Today I received the below error message when executing a SSIS catalog SSIS package from an Agent job:

InitialCatalog_Error

We currently have an Environment Variable that has variables that contain the full connection string of the database:

ConnectionString

We then set the ConnectionString property of the relevant database connection on the Connection Managers tab when configuring the SSIS Catalog:

EnvironmentVariables

The above error was caused by setting the InitialCatalog to use the Environment Variable variable instead of setting the ConnectionString to use the variable. Once the properties were swapped the issue disappeared!

Advertisements

One thought on “An error occurred while setting the value of property “Initial Catalog”

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