http://www.sqlservercentral.com/Content tagged ETL, Integration Services posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)SQL Server 2008 Integration Services (SSIS) provides a flexible and scalable architecture that enables high-performance data extract, transform, and load (ETL). The Microsoft Business Intelligence Center of Excellence has extended SSIS to a metadata-driven platform to more effectively build, deploy, and manage ETL processes in large data warehousing environments.http://www.sqlservercentral.com/redirect/articles/64111/2008/08/19http://www.sqlservercentral.com/redirect/articles/64111/Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us ahttp://www.sqlservercentral.com/articles/Integration+Services/61542/2008/08/22http://www.sqlservercentral.com/articles/Integration+Services/61542/A new series sponsored by Actuality Business Intelligence on data warehousing. In part 1, the data flow in SSIS packages are used to profile the source data and determine how it should be handled in the process.http://www.sqlservercentral.com/articles/ETL/63792/2008/07/23http://www.sqlservercentral.com/articles/ETL/63792/This article demonstrates how to extract, transform and load free-form data into a structured form like a staging table by way of XML conversions.http://www.sqlservercentral.com/articles/ETL/62245/2008/03/20http://www.sqlservercentral.com/articles/ETL/62245/This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable. http://www.sqlservercentral.com/articles/Integration+Services/61880/2008/03/05http://www.sqlservercentral.com/articles/Integration+Services/61880/Microsoft MVP Andy Leonard brings us a great introduction to a common task for all DBAs: importing data.http://www.sqlservercentral.com/articles/SSIS/62063/2008/02/11http://www.sqlservercentral.com/articles/SSIS/62063/Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us ahttp://www.sqlservercentral.com/articles/Integration+Services/61542/2008/08/22http://www.sqlservercentral.com/articles/Integration+Services/61542/Importing text files is a common task for DBA's and Developers, but what happens when the text file is not properly formatted?http://www.sqlservercentral.com/redirect/articles/61420/2007/11/08http://www.sqlservercentral.com/redirect/articles/61420/