Share via

Create a Transaction Commit/Rollback for Oracle DB in SSIS?

  • Article

Oracle supports distributed transactions and MTS, through Oracle Services for Microsoft Transaction Server (OraMTS). You can set the TransactionOption property on your package or on specific containers to Required and this will enlist them in a distributed transaction by installing the OraMTS.
You can find more information on the features in SSIS from this link: https://technet.microsoft.com/en-us/library/ms137690.aspx. A SQL Server example can be found at https://blogs.conchango.com/jamiethomson/archive/2005/08/20/SSIS-Nugget_3A00_-RetainSameConnection-property-of-the-OLE-DB-Connection-Manager.aspx

Comments