Execute SQL task - SQL command from variable built from expression

May 26, 2011 at 11:59 AM

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?

Oct 25, 2011 at 1:57 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.