patternMinor
Searching SSIS packages for the use of specific tables
Viewed 0 times
tablesthesearchingssisforspecificpackagesuse
Problem
I have a number of SSIS packages, how can I search them to find the use of specific tables? I need to make tables changes and I am trying to assess the impact of these.
Solution
SSIS code behind is actually a XML value and all components of package will be represented as XML node values within it.This XML can be parsed to identify if it has a reference for our searched table or column.
Finding SSIS Packages having References to a Table or Column will help you.
Finding SSIS Packages having References to a Table or Column will help you.
Context
StackExchange Database Administrators Q#105611, answer score: 5
Revisions (0)
No revisions yet.