Hi everyone;

I'm planning to use Data Transaction coordinator (DTC) to handle
transactions in my DTS packages for an upcoming data warehouse project

I've done a couple of simple tests with DTS and DTC and everything
worked fine.

Have you encountered any issues with DTC and DTS that hampered your
developments? Any reasons why not to use DTC?

Thanks
Kambiz

DTC is great when it works, but it needs more connectivity compared to plain
SQL over TCP/IP. If you are within the same domain, without firewalls
in-between then you will have no problems. If using with a FW in between
then there is a KB I'm sure that details the ports required,. If this is
across domains then (I think) you need to provide a mechanism for net bios
name resolution. We solved this by using WINS and manually adding the
opposite boxes into the local WINS setup.

Search for MSDTC on the KB and browse some of the articles to get a feel for
what the problems can be.


--
Darren Green
http://www.sqldts.com

"kambiz" <kambizaf (AT) yahoo (DOT) com> wrote