In SSIS (SQL Server Integration Services) you can search the content of the packages. This is useful when you want to know whether a column is used in a source or destination. You may need this when a column in the source database changes and you have to assess the impact.
This column can, for example, be used in several places in the data warehouse. Open your SSIS solution and click “Edit” -> “Find and Replace” -> “Find in Files” at the top, or use the shortcut “CTRL+SHIFT+F”. This way you can search the content of your dtsx files!
Frequently asked questions
How do I search for a text or column name in all SSIS packages (dtsx)?
Open your SSIS solution and choose Edit, Find and Replace, Find in Files. The shortcut is CTRL+SHIFT+F. This way you search the content of your dtsx files.
What is the shortcut to search in SSIS dtsx files?
CTRL+SHIFT+F opens Find in Files. With it you search the content of all dtsx files in your SSIS solution.
How do I know whether a column is used in a source or destination of an SSIS package?
Search for the column name with Find in Files. You then see in which dtsx files the column appears, both in sources and in destinations.
How do I assess the impact when a column in the source database changes?
Search your SSIS solution for the column name with Find in Files. The column can be used in several places in the data warehouse, and this way you find those places.
Can I search the content of dtsx files without opening the packages one by one?
Yes. Find in Files searches the content of all dtsx files of the open SSIS solution at once.
Comments
Related blogs
Date calculations
Finding duplicate rows
Column Usage in Views