Hi guys,
a stupid question, is ETL part of DTS?
if it's not, how do I learn it?

DTS is an ETL tool.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Kevin" <pearl_77 (AT) hotmail (DOT) com> wrote

Hi guys,
a stupid question, is ETL part of DTS?
if it's not, how do I learn it?

Kevin wrote:
No question is stupid if you do not know the answer.

ETL stands for Extract, Transform, Load. It is not an application, but a methodology. It is usually in reference to
putting data into a data warehouse.

Your best bet is to Google for these terms. There are dozens or maybe hundreds of web sites about ETL and data warehousing.

On Thu, 13 Oct 2005 17:36:25 -0400, "Kevin" <pearl_77 (AT) hotmail (DOT) com>
wrote:

Hi,

You have asked one of those seemingly simple questions that could
potentially cause a huge thread.

Microsoft's publicity for SQL Server Integration Services, SSIS, hints
that Data Transformation Services isn't really an ETL tool,
<fireproof_suit_on>more an ELT tool</fireproof_suit_on>. ... I know
I could regret saying that since I can't immediately put my hand on a
reference.

Suffice it to say that both DTS in SQL Server 2000 and SQL Server
Integration Services in SQL Server 2005 can move and transform data.
From a practical point of view, at newbie level, that is maybe all you
need to know.

As a personal comment, if you are starting from scratch and have a
choice about whether to learn about DTS2000 and SSIS, I would suggest
you choose SQL Server Integration Services. DTS, in my view, will
shortly be a legacy application. SQL Server Integration Services is
the way to go.

If your company is using SQL Server 2000 and needs DTS now, then that
constrains your options, obviously.

Andrew Watt
MVP - InfoPath

I would agree with Andrew on his point about DTS being an ELT and less an
ETL tool. That is not to say this is bad but it is a different methodology.
SSIS takes away a lot of the need to ELT and use ETL but it may be a requirement
that you also do still use an ELT approach after a screen etc.

SSIS is definitely a much more competent and powerful animal and given a
choice then it should probably be preferred over DTS (I like DTS though)

Allan