In my case, This error came up in SSIS after some copy-pasting happened in our TFS. I tried opening a package & it gave the “The connection {GUID} is not found…” error. So here’s how I was able to solve it:
1. After I got the latest version of files, I navigated to the Integration Services package file on my local machine.
2. Opened the file in notepad to look at XML.
3. After I was able to see the XML code, I searched for the connection GUID “xyz…” that was showing up in the error
4. Now, once you locate the GUID, figure out the package component that the connection is being used. In my case it was a “Execute SQL Task”
5. I then opened my package and fixed the connection in the Task.
That’s about it for this post. I hope this helps someone out there.
How did you do number 5?
Thanks for this write-up Paras! I totally got that error today while promoting a package to production and this fixed it.
You’re welcome! I hope all is well 🙂
Paras – Thanks a lot. It helps me.