Is there a quick way to determine where the connection is used in the package?
inside the visual studio you can search all instances of the connection string using ctrl + shift + f
I usually right-click on the package and view the XML