Hello,
I am writing a paper as part of my masters on ETL tools and I am in need of
user opinions of Microsoft's DTS (pros/cons). Any input would be greatly
appreciated. Thanks.
Charles Woolard
woolcha (AT) iit (DOT) edu

DTS rocks now and will continue to do so. It is easy to use and has a great
feature set. It is also FREE. I could go on for hours about how I like it.
There are some things that are fiddly. There are also things that are
missing that other vendors provide. Perhaps MS will provide these for us in
the next major release of SQL Server.


--


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

"charles woolard" <woolcha (AT) iit (DOT) edu> wrote

In article <eoIADNbRDHA.632 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, charles woolard
<woolcha (AT) iit (DOT) edu> writes
bonus especially compared to the price of some alternatives. It is very
powerful and extensible too. It has limitations but most can be overcome
with some ingenuity. It allows standard SQL, and uses core (MS)
technologies such as VBScript and COM, as opposed to it's own language
as some ETL tools do. It is by no means perfect, but what is.

I like it a lot, but if that doesn't answer you question please be more
specific.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com