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

Using Script Task in SSIS to resolve problem of NULL values loaded from Excel.  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...

This is a short article on how to translate an exotic join or range lookup in SSIS (Integration Services) from Nick Maroudas.  Read more...

Read more...

This article describes one method of implementing a reporting system in SQL Server 2005  Read more...

This article describes how to call a web service to clean up address data from within a data flow.  Read more...

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

This article describes one method of implementing a reporting system in SQL Server 2005  Read more...

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