Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...

Microsoft MVP Andy Leonard brings us a great introduction to a common task for all DBAs: importing data. (from Feb 2008)  Read more...

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios.  Read more...

This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.  Read more...

In the first article, we learned how to move data into SQL Server. This time Chad Miller shows us how we can use Powershell to extract data out of SQL Server.  Read more...

OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.  Read more...

This article briefly demonstrates a methodology for auditing changes made to data flows during the ETL process.  Read more...

Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.  Read more...

This Article shows a method to audit ETL-Processes to be able to retrace processes and affected data.  Read more...

With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.  Read more...

The following article shows how Change Data Capture can be used to capture incremental data changes and use them in an ETL Process  Read more...

Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.  Read more...

Change Data Capture is a new feature of SQL Server 2008 that can help you better handle your ETL systems. New author Suresh Yaram brings us an introduction to CDC and how it can be setup in your environment.  Read more...

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.  Read more...

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.  Read more...

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...

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.  Read more...

This article provides a step by step guide on how to export data to Microsoft Office Excel 2007  Read more...

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.  Read more...

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.   Read more...