Problem with package transactions and Distributed Transaction Coordinator

• SQL Thetan

  Say Hey Kid

  Points: 664

  More actions

  March 11, 2008 at 5:06 pm

  #93224

  I'm having an issue with a package hanging when it says starting DTC in the progress window. I'm testing how to use transactions in SSIS and created a simple test package. I have the transaction level set to Required on the package level. Here's what my package is doing:

  1. Truncating table A on connection 1.

  2. In the data flow, loading rows from table B on connection 2.

  3. To table A on connection 1.

  So on the control flow window there's only a sql command task and data flow task.

  I checked activity monitor in SSMS and read there was suddenly! a lock by process -2 which was selecting * from table A which is truncated and loaded. The process must have been created by executing the package from what I can tell. I read that pid -2 could mean the DTC.

  Could anyone possibly give me some guidance? Everything (not much that I could think of) I have tried hasn't seemed to help. The DTC is started on the server running SSIS.

  Thanks!

• SQL Thetan

  Say Hey Kid

  Points: 664

  More actions

  March 11, 2008 at 5:14 pm

  #788326

  Sorry, I meant to post this in the SSIS forum. I've tried deleting this thread.