Post reply

Connection not found

  • November 5, 2015 at 4:32 am

    #302015

    Hi guys,

    when opening a package i get the error:

    Error 5 Error loading 02 04 XLS_GL_Load.dtsx: The connection "NHDQCOG01" is not found. This error is thrown by Connections collection when the specific connection element is not found.

    The connection "NHDQCOG01" is never used in the package and was removed sometime ago before my exposure to this project.where can i find where this connection is being referred to and remove it?

    the package works once opened and executed.

    thanks a mil

    Ian

    Ian Cockcroft
    MCITP BI Specialist

  • November 5, 2015 at 4:46 am

    #1837910

    Ian C0ckcroft (11/5/2015)

    Hi guys,

    when opening a package i get the error:

    Error 5 Error loading 02 04 XLS_GL_Load.dtsx: The connection "NHDQCOG01" is not found. This error is thrown by Connections collection when the specific connection element is not found.

    The connection "NHDQCOG01" is never used in the package and was removed sometime ago before my exposure to this project.where can i find where this connection is being referred to and remove it?

    the package works once opened and executed.

    thanks a mil

    Ian

    Try opening the dtsx file in Notepad++ and searching for that text. You'll probably find that there is an unused parameter or expression somewhere which needs to be removed. Once you've located the text, it should be obvious where to look in VS to remove it.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply