Is there a way to call an "Execute SQL Task" from a Data Driven Query VB
Transformation Script?

Thanks

There is no way to do this, and I cannot think why you would need to.

The DDQ offers the 4 "Queries" which execute on a row by row basis, and you
can choose which one to execute by the return value from you script.

If you want more functionality, you should be able to execute more than one
query per row by summing the DTSTransformStatus constants for the two or
more queries.

You can also call lookups from within the script, and there is virtually no
limit to the number of lookups you call, or the number of times you call the
same lookup all in one pass of the script. A lookup doesn't have to return
data, but it can return one or more values. If the parameter support gets
messy you can just wrap the code up in a stored procedure to suppress any
client side validation errors, as these can be a pain, when really the SQL
is fine.

--
Darren Green
http://www.sqldts.com




[quoted text, click to view]