November 5, 2015 at 4:32 am
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
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply