"Todd C" wrote:

> I have a simple package that:
> 1) Truncated data from the Destination Db then
> 2) Copies data from the Source Db.
> These two steps are contained within a Sequence Container.
> Transaction options are as follows:
> Package: Supported
> Seq. COntainer: Required
> Steps within the Container: Supported
>
> When I run the package, I get the following error:
>
> <<The DTC transaction failed to start. This could occur because the MSDTC
> Service is not running.>>
>
> But the DTC is in fact running on both the Source server (SQL 2000, SP3) and
> the Destination Server (SQL 2005).
>
> If I remove the two items from the container, they run fine on their own.
> Ultimately, there will be up to 25 sets of these 'transfers' and I was hoping
> to put each set within its own Transaction. Because of this, I cannot really
> use a Package level Transaction.
>
> Any thoughts out there as to why I am getting the error, even though BOTH
> MSDTC services are running? Could it be the Service Accounts they use? Is it
> relying on the MSDTC of the LOCAL server when it tries to execute in Design
> mode?
>
> Thanks in advance.
>
> Todd C
>
>