Introduction

Microsoft SQL Server Integration Service (SSIS) is one of the leading tools for data integration, data consolidation, and data transformation. It is used by ETL developers, DBAs, and data analysts to extract, transform, and load data in ETL (Extract, Load and Transform) processes, or to do maintenance tasks. There are a lot of out-of-the-box tasks, sources, transformations, and destinations to solve the majority of everyone’s needs, but they never cover 100 percent of everybody’s needs.

Sometimes you need something very specific for your case, which isn’t useful for the majority of the people; or the ever-continuing developments in ICT are just too fast for the SSIS version you are using; and of course, you sometimes just wonder ...

Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.