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
  • 34,224
  • 11
  • 61
  • 121
Esperanza
  • 115
  • 9

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
  • 34,224
  • 11
  • 61
  • 121