MS SQL Server DTS - DTS Transaction

Author

DTS Transaction

Leo Quezada

2005-09-28, 8:24 pm

Hi,

I have Windows Server 2003 Enterprise and SQL 2000, when i executed my DTS
package i receive this error:

Beginning of Package Transaction failed when executing Step
'DTSStep_DTSDataPump
Task_1'.A connection with the transaction manager was
lost.

Whitin the Package Properties I use transactions.

The same DTS packege works in Windows Server 2000 but not in 2003.

any idea ?

Thanks

Allan Mitchell

2005-09-28, 8:24 pm

Do any of these discussions/articles help you

[url]http://www.google.com/search?sourceid=navclient&ie=UTF-8& q=%22A+Connection+wi
th+the+transaction+m
anager+was+lost%22+[
/url]

Allan

"Leo Quezada" < LeoQuezada@discussio
ns.microsoft.com> wrote in message
news:1FD4C992-92BB-4E9B-90AA- 3C25E97276E7@microso
ft.com:

> Hi,
>
> I have Windows Server 2003 Enterprise and SQL 2000, when i executed my DTS
> package i receive this error:
>
> Beginning of Package Transaction failed when executing Step
> 'DTSStep_DTSDataPump
Task_1'.A connection with the transaction manager was
> lost.
>
> Whitin the Package Properties I use transactions.
>
> The same DTS packege works in Windows Server 2000 but not in 2003.
>
> any idea ?
>
> Thanks

Sponsored Links