Extending SSIS with .NET Scripting

A Toolkit for SQL Server Integration Services

  • Authors
  • Joost van Rossum
  • Régis Baccaro

Table of contents

  1. Front Matter
    Pages i-xxv
  2. Getting Started

    1. Front Matter
      Pages 1-1
    2. Joost van Rossum, Régis Baccaro
      Pages 3-30
    3. Joost van Rossum, Régis Baccaro
      Pages 31-54
    4. Joost van Rossum, Régis Baccaro
      Pages 55-66
  3. Script Tasks

    1. Front Matter
      Pages 67-67
    2. Joost van Rossum, Régis Baccaro
      Pages 69-114
    3. Joost van Rossum, Régis Baccaro
      Pages 115-144
    4. Joost van Rossum, Régis Baccaro
      Pages 145-174
    5. Joost van Rossum, Régis Baccaro
      Pages 175-193
    6. Joost van Rossum, Régis Baccaro
      Pages 195-215
  4. Script Component

    1. Front Matter
      Pages 217-217
    2. Joost van Rossum, Régis Baccaro
      Pages 219-241
    3. Joost van Rossum, Régis Baccaro
      Pages 243-265
    4. Joost van Rossum, Régis Baccaro
      Pages 267-293
    5. Joost van Rossum, Régis Baccaro
      Pages 295-310
    6. Joost van Rossum, Régis Baccaro
      Pages 311-326
    7. Joost van Rossum, Régis Baccaro
      Pages 327-348
    8. Joost van Rossum, Régis Baccaro
      Pages 349-381
  5. Custom Tasks and Components

    1. Front Matter
      Pages 383-383

About this book

Introduction

Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. All examples are in both C# and VB.NET, and work for all current versions of SSIS.

SSIS is one of the leading ETL, Data Consolidation, and Data Transformation tools in today’s market. SSIS is used by ETL Developers, DBAs and Data Analysts to transform data as required for different ETL processes. There are many built-in components and tasks to help developers to perform actions. For example, there are tasks for sending and receiving files through FTP, sending an email, and for accessing a wide range of database management systems. Yet there are times when developers require a task or component that does not exist and it would make their life much easier if they could create that task or component, and that is what this book it is about. It shows how to write .NET scripts and use the powerful Microsoft .NET library to implement new functionality as needed.

  • Provides a timeless scripting toolkit for all current SSIS versions
  • Gives a comprehensive explanation of scripting in SSIS
  • Offers a wide array of readymade examples for everyday problems

    Bibliographic information

    Industry Sectors
    Pharma
    Automotive
    Electronics
    Telecommunications
    Aerospace