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.
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.