2

Background

Migrating from SSIS2008 to 2016. Using SSDT2015

Question

Is there a script or any automation method to quickly list the Connection Managers used by all controls (both in Control Flow and Data Flow) in a project? Currently I'm opening each control to identify the Connection Manager.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Esperanza
  • 115
  • 10

1 Answers1

0

I don't think there is an easy solution for your question, you have to "deserialize" the ssis package, you can do this programmatically using C# or Vb.net or you have to use regular expressions. You can get more info from this question: Reverse engineering SSIS package using C#

Hadi
  • 36,233
  • 13
  • 65
  • 124