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.yqcomputer.com/