SSIS - Search in files

Peter Schmitz

Staff member
Recently I wanted to know which of my packages contained SQL that referenced a specific table. I ended up copying all packages to a folder, and painstakingly performing a text-based search in the files to find the table in the script.

Today, a colleague showed me this is actually possible inside Visual Studio. To do so, simply use CTRL + SHIFT + F. Alternatively, you can find it in the menu, by checking Edit -> Find and Replace -> Find in Files.