"Find unused variables" found a variable that was used.

[Carman1982]

Describe the bug
Opened a DTS. Opened Variables at bottom. Clicked the "Find Unused Variables". Found that one of the variables was actually being used. Noticed that Find Variable References window did find the reference to the variable.

Version

To Reproduce
Opened a DTS.
Opened Variables at bottom.
Clicked the "Find Unused Variables".
Found that one of the variables was actually being used.

Expected behavior
Not show variables being used.

Screenshots
Screen shot of Find Unused Variables window

Screen shot of the Find Variable References window

Additional context
Feels like the Find Unused Variables is not looking at Expressions on other variables?

[sqlgreen]

@Carman1982 thank you for reporting the issue and the great bug report. The matching logic would only handle the matching one variable in an expression (the first it found based on test order), which was OK for Find Variable References feature, but not so good for the Find Unused Variables.

Fix now in, and will look to do a release soon.

(Sorry for the slow response, different SSDT versions are just painful for extension development and I was a bit behind)

[Phil-Greenlight]

I have just encountered an analogous issue with parameters.

I have a project parameter which is referenced in a variable's expression (within the package being edited).

Find Unused Parameters identifies this parameter.

Find Parameter References does not appear to do anything at all. No popup window is displayed.

This is VS2017 targeting SQL Server 2017. BI Developer Extensions For Visual Studio 2019 - 2.3.7.

[cyprox972]

Is this problem supposed to be fixed? I still have the exact same problem as reported, running version 2.4.0 in VS 2017 with SQL Server Data Tools v15.1.62002.01090

[Phil-Greenlight]

I ended up writing my own routine for this. Check this link if you are interested.