Microsoft ETL Tools in datawarehousing?

I would like to know what are the Microsoft Extraction Load %26 transform (ETL) tools available in the market

Microsoft ETL Tools in datawarehousing?house call

Microsoft has two ETL tools. SQL Server 2000 and earlier has DTS - Data Transformation Services. It is a component built into SQL Server that moves data via a Designer style palette. Not really an ETL tool, more like a ELT tool and stored procedure code generator with some admin tasks.

SQL Server 2005 has SSIS (SQL Server Integration Services), a rewrite of DTS that has a more traditional ETL client server architecture and a workflow designer for building jobs that move data. They are built and tested within the BI development studio.

There are also a large number of ETL tools from other vendors that run on Windows and can access Microsoft SQL Server or Access databases.