Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

SSIS - Search in files

Discussion in 'Business Intelligence' started by Peter Schmitz, Jul 4, 2017.

  1. Peter Schmitz

    Peter Schmitz Administrator 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.

Share This Page