Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

SSIS - Error: "an item with the same key already been added"

Discussion in 'Business Intelligence' started by Peter Schmitz, Jun 15, 2017.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    A colleague of mine just ran into the following error:

    At the time he was copying some objects from one SSIS package to another, as he had been doing most of the day. However, all of a sudden this error popped up to ruin his day. He didn't actually try to save or do anything, but even just clicking back to the original package would pop up this error.

    There was no immediate indication of what happened, but a bit of digging revealed that for some reason a copy of an existing Connect Manager was added to the Project's Connections Managers.

    We solved it by deleting the redundant Connection Manager.

Share This Page