"Royce Lithgo" <Royce.Lithgo@sg.standardchartered.com> wrote in message
news:073301c3608a$52fe59a0$a601280a@phx.gbl...
> Sorry for all the postings, but I've found something new.
> I tried a new DTS package, this one copying data from SQL
> Server to SQL Server tables (ie. No Oracle objects
> involved). I changed the properties of each step to set
> JoinTransactionIfPresent and Rollback Failure to true.
> When I run the package I'm still getting the MSDTC error
> message:
>
> The Microsoft Distributed Transaction Coordinator (MSDTC
> Service) is not available.
>
> The Service is running on the server!! Any ideas? Is it
> ok for the service to run as the local System user?

>-----Original Message-----
>Which OS are you running? Windows Server 2003?
>
>Is the MSDTC service running on both the source and the=20
destination SQL
>Server and on the server where you execute the DTS=20
package?
>
>Did you do a "NET START MSDTC" ?
>
>GertD@SQLDev.Net
>
>Please reply only to the newsgroups.
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.
>You assume all risk for your use.
>Copyright =A9 SQLDev.Net 1991-2003 All rights reserved.
>
>"Royce Lithgo" <Royce.Lithgo@sg.standardchartered.com>=20
wrote in message
>news:073301c3608a$52fe59a0$a601280a@phx.gbl...
>> Sorry for all the postings, but I've found something=20
new.
>> I tried a new DTS package, this one copying data from=20
SQL
>> Server to SQL Server tables (ie. No Oracle objects
>> involved). I changed the properties of each step to set
>> JoinTransactionIfPresent and Rollback Failure to true.
>> When I run the package I'm still getting the MSDTC error
>> message:
>>
>> The Microsoft Distributed Transaction Coordinator (MSDTC
>> Service) is not available.
>>
>> The Service is running on the server!! Any ideas? Is it
>> ok for the service to run as the local System user?
>
>
>.