Transaction Control

Explain Why it is bad practice to place a Transaction Control transformation upstream from a SQL transformation?

Questions by krish_80   answers by krish_80

Showing Answers 1 - 2 of 2 Answers


  • Nov 21st, 2009

First Thing as mentioned in the Other Posts it drops all the incoming transaction control boundries.
Besides you can use Commit and Rollback statements within SQL Transformation Script to control the transactions, thus avoiding the need for the Transaction Control Transformation.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions