22-25 April 2026

Step-by-step towards building a SSIS Custom Pipeline Component

Proposed session for SQLBits 2026

TL; DR

Introduction to SSIS Custom component development avoiding the "usual" pitfalls.

Session Details

Custom Pipeline Components are powerful building blocks to tackle specific issues with SSIS. However, starting to build them, can be tricky. This session introduces the basic concepts and shows the initial steps to ease around some of the common issues.
The session will be a step by step demo to programming a generic Custom Pipeline Component. The complete process from setting up a matching Visual Studio project to deploying and debugging will be shown.
Only free tools will be used. Basic C# knowledge is recommended.

3 things you'll get out of this session

Encourage own SSIS development