SQL Server Integration Services ETL Platform
|Details:||The article examines some of the most useful features of Microsoft SSIS to build ETL applications. It contains a guide on how to build a simple package using the key SSIS component - Business Intelligence Development Studio. The article enumerates the most significant SSIS features around scalability, integration with other Microsoft BI applications and third party vendors, data cleansing, data mining and considerations on Slowly Changing Dimensions.
It provides an illustrated step by step tutorial containing an example that shows how to construct and execute a package using the Microsoft SSIS Business Intelligence Development Studio environment.