• Since this issue, in other packages I've built,

    I have found that if in the same package,

    there is a truncate task of the same table I am loading

    then DTC will lock up, but SQL transactions will not.

    If that is your situation, you might try putting the truncate in a separate package all together and then use a master controller package to control the flow from truncate to loading packages.

    But I have had DTC hang on that server even without the truncate task and have been tending to avoid it.

    hth

    Skål - jh