Unisys and Microsoft have dispelled the perception that for high performance ETL, the only alternative is a UNIX-based solution. With SQL Server 2005 Integration Services, Microsoft and Unisys deliver an optimized ETL solution that will support even the most demanding enterprise Business Intelligence (BI) initiatives. They conducted a series of real ETL (Extraction, Transformation and Load) tests with Microsoft SQL Server 2005 Integration Services (SSIS, formerly known as DTS). Performance tests compared throughput, scalability and performance on both 32- and 64-bit processor configurations on a Unisys ES7000. SSIS demonstrated parallelism and the ability to utilize all available CPUs in multiple aggregation, parallel lookup and transformation testing.
Read the rest of this entry »