We Loaded 1 Terabyte in 30 Minutes with SSIS, and So Can You

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.

SSIS Package Execution

Using The Data Profiler Task and FTP Task in SQL Server 2008 Integration Services

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

Trace File Source Adapter

The Trace File Source adapter is a useful addition to your SSIS toolbox. It allows you to read 2005 and 2008 profiler traces stored as .trc files and read them into the Data Flow. From there you can perform filtering and analysis using the power of SSIS

Searching for tasks with code – Executables and Event Handlers

Searching packages or just enumerating through all tasks is not quite as straightforward as it may first appear, mainly because of the way you can nest tasks within other containers. You can see this illustrated in the sample package below where I have used several sequence containers and loops.

Understanding SSIS Data Flow Buffers (SQL Server Video)

This video looks at the memory buffers that transfer data to the data flow of an Integration Services package.

Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video)

This video demonstrates how to improve the performance of the data flow in an Integration Services package. In this video, you will learn how to tune the following phases of the data flow: Extraction, Transformation, Loading

Simple Steps to Creating SSIS Package Configuration File

This new article from Lanre Famuyide shows how to make your SSIS package deployment hassle free by using package configuration files.

Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)

For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance.

Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach

Script Task in SSIS can provide simpler implementation of complex mail functionality in comparison to Send Mail task.