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!