http://www.sqlservercentral.com/Content tagged ETL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article provides a step by step guide on how to export data to Microsoft Office Excel 2007http://www.sqlservercentral.com/redirect/articles/63451/2008/07/04http://www.sqlservercentral.com/redirect/articles/63451/Tool to automatically query combinations of columns in your table to determine candidate for unique key.http://www.sqlservercentral.com/scripts/T-SQL/62086/2008/04/16http://www.sqlservercentral.com/scripts/T-SQL/62086/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/http://www.sqlservercentral.com/questions/ETL/61995/2008/01/22http://www.sqlservercentral.com/questions/ETL/61995/This article describes one method of implementing a reporting system in SQL Server 2005http://www.sqlservercentral.com/articles/Reporting+System/61688/2008/01/21http://www.sqlservercentral.com/articles/Reporting+System/61688/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/01/09http://www.sqlservercentral.com/articles/Integration+Services/61542/http://www.sqlservercentral.com/questions/ETL/61630/2007/12/10http://www.sqlservercentral.com/questions/ETL/61630/Robyn and Phil return with some fresh ideas about how to import text files into SQL Server, without resorting to DTS or SSIS scripting. They go on to show how much can be done in TSQLhttp://www.sqlservercentral.com/redirect/articles/61459/2007/11/19http://www.sqlservercentral.com/redirect/articles/61459/http://www.sqlservercentral.com/questions/T-SQL/61444/2007/11/09http://www.sqlservercentral.com/questions/T-SQL/61444/ETL processing, generally involves copying/moving, transforming, cleaning the records/transactions from one or multiple sources. Most of the batch processing or warehousing projects involve such data processing in millions on daily/weekly basis. Typically, there is a Staging area and production area. Records are cleaned, transformed, filtered and verified from staging to production area. This demands SQL Set theory based queries, parallel processing with multiple processors/CPU. The article focuses on need of SQL Set theory approach and parallel processing while processing large volume of ETL records using programming approach. http://www.sqlservercentral.com/articles/ETL/61480/2007/11/08http://www.sqlservercentral.com/articles/ETL/61480/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/These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.http://www.sqlservercentral.com/redirect/articles/61413/2007/11/01http://www.sqlservercentral.com/redirect/articles/61413/