Re: DTS transaction

#1

Not AFAIK unfortunately.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rashmi" <rashmi_nailady (AT) instron (DOT) com> wrote

Quote:

Is there a way to enclose a DTS package in a transaction
without using MSDTC. Our server is hosted and they don't
support DTC because of the firewall issues.
Is there any other way to enclose a DTS in a transaction
without using the join transaction if present option. If
you can think of any workaround, please advice.

Thanks

#2

Is there any other way to transform data from client to
server that reside on different domains, other than using
dts.

Quote:

-----Original Message-----
No that is not possible.

GertD (AT) SQLDev (DOT) Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and
confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.

"Rashmi" <rashmi_nailady (AT) instron (DOT) com> wrote in message
news:0a7201c365c4$f0c9ac90$a001280a (AT) phx (DOT) gbl...
Is there a way to enclose a DTS package in a transaction
without using MSDTC. Our server is hosted and they don't
support DTC because of the firewall issues.
Is there any other way to enclose a DTS in a transaction
without using the join transaction if present option. If
you can think of any workaround, please advice.

Thanks

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS transaction

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS transaction - 08-19-2003 , 01:14 AM

Re: DTS transaction - 08-19-2003 , 10:37 AM