Data Mining Model Training Destination in SQL Server Integration Services

How to incorporate data mining directly into the Data Flow of SQL Server 2008 R2 Integration Services-based packages.

A VB.NET toolkit for writing SSIS Script Tasks

This article demonstrates basic VB.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.

Extracting and Loading SharePoint Data in SQL Server Integration Services

The SharePoint List Source and Destination Sample available on Codeplex provides an optimized solution with an easy-to-use interface for getting data out of or into a SharePoint list. The sample also includes an API for accomplishing these tasks efficiently outside of SQL Server Integration Services.

Extract multiple files from multiple directories with a data flow task

This article shows how to extract multiple files from multiple sub-directories into a destination table using a single Data Flow Task created by the Import/Export wizard.

Extract multiple files with a MultiFlatFileConnection data flow task

A data flow task generated by the SSIS Import and Export Wizard can be configured to extract data from multiple files by changing the default connection manager to a MultiFlatFileConnection.

Debugging Data Flow in SQL Server Integration Services

You can save a lot of time by using the SSIS Troubleshooting tools. These enable you to work with reduced data samples, monitor row counts, use data viewers, configure error-handling and monitoring package execution. Although you can develop SSIS packages without them, it is so much easier once you're familiar with these tools.

Installating SSIS with Named Instance

Find Job Names that Contain SSIS Packages and their Location

This will give you a list of jobs that contain SSIS Packages should you have a project in which you may need to review changes to Packages.

SQL Server 2008 and 2008 R2 Integration Services - FTP Task

FTP Task lets you copy files across distributed, frequently incompatible systems.

SQL Server 2008 and 2008 R2 Integration Services - Consuming Web Services Using Script Task

Web services can be easily leveraged in SQL Server 2008 R2 Integration Services by employing Web Services Task.