sql server dts: Hi Allan
1)Is there any site which would explain the Process of
Extract Transform Load in a detailed manner?
2)Is ETL A part of datawarehousing ?if so how?
3)How well does DTS Support the concept of ETL is there
any documentation on DTS Support for ETL

Thanks in advance

Wow.

1. Sites:

http://www.datawarehouse.com/iknowledge/articles/article.cfm?ContentID=4072
http://www.evaltech.com/wpapers/dwandetlprocessing.htm


2. My answer to this is no. ETL is about Extracting information from a
place, Transforming/cleansing it or not and finally loading it to a place,
maybe the same place maybe a different one. A Data Warehouse doesn't need
to be involved although very very frequently is.

3. DTS is a good ETL tool. It does not, in this release, support
everything that other vendors support. I am not sure there are tenets to
ETL like Codds NFs unless you take the ETL to be the tenets..

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]