DSXchange

Is it possible use a conditional in the connector stage to execute a different query based the value of a variable? The BEGIN WORK clause is throwing an error when I try.

Not sure but might depend on your definition of 'conditional' - can you give us some examples of what you'd want to do based on a variable? What would vary? Do they all have the same metadata?

<edit: removed bogus target suggestion>

I am trying to implement something similar to the following logic which works in Sybase. The metadata is identical.

IF <Condition>

BEGIN

Sql1

END

ELSE

BEGIN

Sql2

END