19
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 12:15 PM

Also

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

furmangg wrote Jun 23, 2011 at 4:28 PM

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

wrote Aug 31, 2011 at 2:06 PM

wrote Sep 14, 2011 at 2:59 PM

wrote Jan 5, 2012 at 8:39 AM

ValentinoVranken wrote Jan 5, 2012 at 8:48 AM

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

wrote Jan 5, 2012 at 9:05 AM

wrote Jan 5, 2012 at 11:37 AM

wrote Jan 9, 2012 at 4:27 PM

wrote Feb 8, 2012 at 3:59 AM

wrote Mar 21, 2012 at 3:43 PM

wrote Aug 24, 2012 at 3:22 PM

wrote Aug 28, 2012 at 2:48 PM

wrote Oct 1, 2012 at 12:20 PM

wrote Feb 22, 2013 at 12:41 AM

wrote Apr 19, 2013 at 2:01 PM

wrote Jun 14, 2013 at 8:41 AM

wrote Sep 6, 2013 at 2:16 PM

wrote Sep 11, 2013 at 7:03 PM

wrote Sep 30, 2013 at 4:13 PM

wrote Aug 8, 2014 at 11:23 AM

wrote Sep 24, 2014 at 1:22 PM

VGDev wrote Sep 24, 2014 at 1: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!

wrote Jan 17 at 3:14 PM

hafnera wrote Aug 17 at 2:04 PM

Up-vote from me as well! This would be VERY helpful!