I posted a question last w

whether, in a Data Driven Query script, it's possible to do the
following:
IF (condition 1) THEN
.
.
Main = DTSTransformstat_UpdateQuery
Main = DTSTransformstat_InsertQuery
END IF
i.e. to call two queries consecutively if a specific condition is
satisfied.
I decided to press ahead and just hope that this would work...however,
it appears that unforrtunately it doesn't work!!
I would be so grateful if anyone knows any way of either getting the
script to execute both queries as above...or, alternatively, if anyone
knows of any way I can have two query statements in the one 'query' (or
another possible way of maybe doing this)?
DTS has such a rich programmable interface in every other way, I cannot
believe that there's no way of achieving this one simple requirement!
Thank you so, so much in advance for any help or pointers anyone can
provide.
CSSUCCESS! You can do it the second way - you can have two queries in the
same 'Query' window/area/function/call-it-what-you-like.
No comments:
Post a Comment