Reputation: 10063
I have 6 .dtsx (design) files (job steps) in visual studio.
For the most part the job steps run .sql code and drop/create/copy tables.
How can I search for where a particular table is touched?
I tried control-F and I browsed the menu for search options.
Upvotes: 2
Views: 1486
Reputation: 37313
I don't think you can achieve this from visual studio.
If you open .dtsx
files with a text editor it contains xml data. So you can search these files for a specific datatable from a text editor (like notepad, notepad++).
Upvotes: 1