Well, it started happening again with a much smaller simpler package (we stopped using SSIS for the primary SQL ETL mentioned before).

This one is a straight forward text file import.

I added Transactions = Requred atthe package level.It's worked fine for a couple days and this morning it started hanging again just like the other big one. Gets to the data flow task, turns yellow and just stops and hangs till I kill it. When I remove Transactions and set it to Supported it runs.

Maybe we just can't use the Distributed Trans. Coord., have to see how to wrap the data flow in a SQL Transaction.