CODEWITHSUNDEEP
ssis
Sreejesh Kumar
Sreejesh Kumar

Reputation: 2499

SSIS 2008 Transactionoption

i have set the TransactionOption as Required in my SSIS package. But the package fails. The error shown is some MSDTC error. I am not able to get it. is there any settings to be changed or done in the machine or server we are deploying/running/working the package ? So wat all steps should we have to follow for setting Transaction in a package.

Upvotes: 0

Views: 491

Answers (1)

David Charron
David Charron

Reputation: 21

"The built-in transaction support in SSIS makes use of the Distributed Transaction Coordinator (MSDTC) service which must be running. MSDTC also allows you to perform distributed transactions; e.g. updating a SQL Server database and an Oracle database in the same transaction."

How To Use Transactions in SQL Server Integration Services SSIS

I hope this helps

Upvotes: 2

Related Questions