18
Vote

SSIS 2008 - "Find all references" feature for variables

description

It would be useful to provide an working version of VS2008's "Find All References" for a varaiable used in BIDS.
 
Scenario:
1) Select variable - from variables panel if possible or from a dialog box filtering by variable containment hierarchy
2) Show components that use that variable for example
 a)  Read-only variable list
 b) Read-write variable list
 c) Used within a property expression
 d) Used within a derived column
 e) Used within a conditional split

comments

jm99 wrote Nov 21, 2010 at 1:15 PM

Also

f) Used within a conditional expression within a task dependency link

furmangg wrote Jun 23, 2011 at 5:28 PM

also, highlighting unused variables as described here:
http://bidshelper.codeplex.com/discussions/262490

ValentinoVranken wrote Jan 5, 2012 at 9:48 AM

One more upvote for the "Highlight unused variables" feature!

VGDev wrote Sep 24 at 2:23 PM

Connection strings too. I have a large package and need to find each task that is using one specific connection out of multiple. A Find All would be so very helpful. Also, please apply to newer versions of SSIS (or SSDT) as well!