This project has moved and is read-only. For the latest updates, please go here.

Execute SQL task - SQL command from variable built from expression

May 26, 2011 at 12:59 PM

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?

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