Learning about practical Integration Services is an important part of the well rounded DBA for the future. Read a sample chapter from this new book.  Read more...

Get a feel for this book from   Read more...

The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.  Read more...

Caught in between upgrades, new author Mohan Jumar has an interesting article. Using Visual Studio 2005 to save packages in an SSIS 2008 package store.   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...

See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.  Read more...

This white paper provides an overview of the connectivity options that are available for SQL Server 2008 Integration Services.  Read more...

Follow a detailed walkthrough of using the Web Service Task to connect to a web service and return an XML result.  Read more...

This article examines the File System Task which can perform numerous operations on files and directories such as create, move, delete, and also to set the attributes of files and folders.  Read more...

The process to use a vb script task to check for a file existence over a time range.  Read more...

This article is the first in a series of articles that will be covering all the Control Flow Tasks and Maintenance Plan Tasks in SQL Server 2008 Integration Services  Read more...

This article is final part of a 5 part series that explores the SSIS features introduced in SQL Server 2008. The final artilce in the series will explore VSTA support for the Script Task and Script Component, Import And Export Wizard Enhancements and how SSIS leverages SQL Server 2008 features.   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...

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

Backpressure is an interesting internal memory limiter inside SSIS and in SQL Server 2008 you get to see when the limiter kicks in.  Read more...

The Multicast transform in SSIS 2005 enables us to take 1 input dataset and from it generate n output datasets that are an exact copy of the input dataset which is extremely useful at times and we have used it on a number of projects.  Read more...