SSIS 2012: Failure Saving Package: An Item With the Same Key Has Already Been Added

I ran into this error today in SQL Server 2012. It was caused by having promoted a package-level connection manager to project-level and then copying and pasting some data flow components from one package to another in the same project.

By copying the data flow components from one package to another, the SSIS designer also copied a reference to the connection manager, but apparently didn’t catch on to the fact that it was a project-level connection. Thus, it duplicated the connection manager’s key in that package which caused the error described above.

The solution was, after having pasted the data flow components, to remove the newly added package-level connection manager which will make the project-level connection manager show. Then attempt to save again and it should work.

by Sven Aelterman

Advertisements

6 thoughts on “SSIS 2012: Failure Saving Package: An Item With the Same Key Has Already Been Added

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