Executing standalone SQL statement

[gmorgen1]

Can I execute a standalone SQL statement in an ODBC stage without having to attach a dummy transform stage?

Or is the preferred (and only) approach to utilize a Stored Procedure stage?

[dsscholar]

I dont think that's possible. You need to have a output link from the ODBC stage to execute the SQL

[ray.wurlod]

It's not possible. Passive stages, like the ODBC stage, only expose methods for performing tasks. Active stages, like Transformer stages, generate processes that actually invoke those methods.

[gmorgen1]

How would I then exectue a series of truncate table and insert statements in a job?

[ray.wurlod]

Separate jobs. To truncate a table, generate just one row (to trigger the operation) and use user-defined SQL. Or, if the stage type permits, choose "truncate table then insert rows" as the load method, so that you don't need to re-invent the wheel.