Thursday, February 9, 2012

Alternative to DTC? - SSIS Transactions - Quick Question

Hi:

I would like to have my SSIS tasks to be transacted, but due to infrastructure issues in our network, cannot utilize DTC, because our SQL Boxes are situated where the DTC cannot communicate. Are any other alternatives? Is it a feasible alternative? Please let me know. Thanks.

MA2005 wrote:

Hi:

I would like to have my SSIS tasks to be transacted, but due to infrastructure issues in our network, cannot utilize DTC, because our SQL Boxes are situated where the DTC cannot communicate. Are any other alternatives? Is it a feasible alternative? Please let me know. Thanks.

This link should help: http://msdn2.microsoft.com/en-us/library/ms137690.aspx

No comments:

Post a Comment