I've been trying the tool out and I'm quite impressed. I have noticed one thing that doesn't seem to work though - we have some instances where we have an Execute SQL Task which runs a SQL statement from a variable. The variable is constructed using an expression
and is thus dynamic. The tables referenced by these statements are not shown as dependencies in the viewer.
Is there a setting that I can change or argument I can specify for the analyzer to try to parse these kinds of statements?
I've been trying the tool out and I'm quite impressed. I have noticed one thing that doesn't seem to work though - we have some instances where we have an Execute SQL Task which runs a SQL statement from a variable. The variable is constructed using an expression and is thus dynamic. The tables referenced by these statements are not shown as dependencies in the viewer. Is there a setting that I can change or argument I can specify for the analyzer to try to parse these kinds of statements?