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.
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.
I was looking for a similar solution, to find references of a table in all the SSIS packages I have.
The solution that worked for me was simple, I copied all the SSIS packages that needed to be searched to a folder and used the 'Find in Files' function from notepad++ wherein you can provide the search string and the path to this folder.
It works on the basis that dtsx can be edited as xml on notepad++. I am sure there are other solutions. Hope it helps.