Single Transaction in Rhino ETL

[Wildjoe182]

Hi,

In Rhino ETL, is it possible to have an entire process, or even
multiple processes, use a single connection and transaction for all
operations?

Regards,

Joe

[Jason Meckley]

input operations provide the option to use a transaction. if you set this to false and wrap the process in a system transaction, all inputs will be in the same transaction. output operations use a transaction and there isn't a way to override it, IIFC. To include the output commands in the same transaction you need to implement your own output commands. i did this on a project a while back and just copied the database output operations into my own objects and removed the begin/commit/rollback transaction code.