I am trying to apply TRANSACTION statements in an SSIS package using ODBC. The typical BEGIN TRANSACTION ... ROLLBACK TRANSACTION ... and COMMIT TRANSACTION.
However, I discovered that ODBC doesn't allow TRANSACTION statements.
I found this link
that says what to use instead if using ODBC, but it gives no examples at all on how to properly use these commands, and I'm having a hard time finding examples online.
Can someone please point me to a website, or provide in the comments, instructions on how to properly use SQLSetConnectAttr and SQLEndTran to do a rollback when a step in the job fails?