SSIS Error, Solution: This error is thrown by Connections collection when the specific connection element is not found

Typically SSIS will throw this error if a connection used by SSIS package is either deleted or renamed. Most of the time it will be a human error, when we copy SSIS package and modify the package, renaming and deleting the connection strings.

Possible solutions:
• Check if this is a human error, one of the task is using a connection string which is deleted of renamed. Just correct it!
• If you are using XML for configuration, re-deploy
• If the package is working as expected in Visual Studio but if you get the error when running it as SQL Job (You must be using Project level connections which re not accessible at package level), you may need to
o Convert the package deployment model

Actual Error:
Error 1 Error loading XYZ.dtsx: The connection “{XYZ-XYZ-…}” is not found.
This error is thrown by Connections collection when the specific connection element is not found.

In my case, one of the event handler task was pointing to old connection which was deleted, deleting the unused event handler task fixed the problem.
I end up opening the package in XML format to understand that the problem is with event handler task!

Advertisements
This entry was posted in SQL, SQL Error, SSIS and tagged , , , . Bookmark the permalink.

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