Creating packages in code - Flat File Source to OLE-DB Destination

This code sample programmatically creates a package that imports a text file into SQL Server, with a Flat File Source and the OLE-DB Destination. This shows how you can leverage the SSIS engine to write your own data import tool for example, but beware importing files is not as simple as it may seem

SSIS New Features in SQL Server 2008 - Part 5

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.

Using Containers with Checkpoints (Part 2)

Continuing on with his series on checkpoints, Aaron Akin now looks at how various types of containers can be used with checkpoints and Integration Services.

SSIS - An Inside View Part 2

This article is part 2 of a 4 part series that explores the internals of SQL Server Integration Services. This article looks at SSIS Transformations and Execution Trees.

Using Checkpoints in SSIS (Part 1)

SSIS is a great platform for building ETL type applications with SQL Server. One of the great features that you can use are checkpoints, which allow you to restart a package that is partially completed. New author Aaron Akin starts a series on how to use this depth.

SSIS Script Tasks

SSIS - An Inside View Part 1

This article is part 1 of a 4 part series that explores the internals of SQL Server Integration Services. This series will focus on the SSIS architecture, buffer management, types of transformation, the execution tree and parallel processing.

SQL Server Integration Services Features And Properties Part 4

This article is the final article of a 4 part series that explores the Features and Properties of SSIS. This article will explore Validation.

SSIS 101: Isolating Data in a Data Flow

MVP and SSIS expert Andy Leonard brings us a new article on how to work with a data flow and manipulate your data in complex ways.

Creating packages in code - OLE-DB Source to Flat File File Destination

This code sample programmatically creates a package with an OLE-DB Source and a Flat File Destination, and the resulting package exports data from SQL Server to a CSV file. The finished package just has the one Data Flow Task shown below.