This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary.  Read more...

This article describes how to use variables in SSIS to dynamically generate folders and file placement.  Read more...

The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer.  Read more...

This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated.  Read more...

You can manage SSAS objects using AMO and SSIS which enables you to have detailed control of SSAS Administrative tasks.  Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

Describes different uses of the SSIS Foreach Loop container in one practical scenario.  Read more...

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