I have an SSIS package that contains a connection manager used for logging. The logging service has been deprecated and I have been tasked with removing references to it from the package. Before I delete the connection manager, I need to remove all references to it, but I haven't been able to figure out how to do that. Can anyone give me any advice? The target server of the package is SQL SERVER 2012, and I am editing the package with Visual Studio 2017.
How to Remove All Database Connection Dependencies in an SSIS package
563 views Asked by Riggster At
1
You would likely spend more time in analysis than just killing the connection manager and following the error list as your clean up punchlist.
Lather, rinse, repeat for all packages.
If you need to provide a list beforehand, you could reverse engineer the package to Biml and then you'd have a much smaller domain of XML to sift through looking for references to your connection manager.