Hi All,

With SSIS, upon load, I am receiving the following error:

Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1

I have gone through all of my connections to find that bugger that has a "" for a connection name but cannot locate it. Can anyone suggest a way, perhaps through VB and BIDS, to find that bad connection and then delete it? I want to go live with this but cannot until I find and remove this bugger. Any and all help is always appreciated.

I don't have code that is looking for the bad connection. Sorry for the confusion. When I open the package, I immediately receive the error that the connection "" has not been found. I was hoping to run some code to find that connection and delete it if possible.

I'm starting to look through the XML portion of my package and I'm hoping to find the error there. LoL, there's over 30,000 lines so this may take me a while.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.