Transactions in SSIS [Resolved]

Posted by Sriharim under Sql Server on 5/14/2015 | Points: 10 | Views : 479 | Status : [Member] | Replies : 2
Where we can write the transactions in SSIS(Sql Server Integration Services) ?

What setting/properties need to set when transactions are used in Tasks ?

Mark as Answer if its helpful to you
---
Srihari



Responses

Posted by: Sriharim on: 5/15/2015 [Member] Starter | Points: 25

Up
0
Down
In the link http://www.mssqltips.com/sqlservertip/1585/how-to-use-transactions-in-sql-server-integration-services-ssis/
package is there, i am getting error when i run the package,

Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running.


please suggest , how to overcome the error

Mark as Answer if its helpful to you
---
Srihari

Sriharim, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response