SSIS Custom Components

Designing custom components for SSIS is a complex task.   
Much of the available documentation is not very intuitive, and although technically correct, can be simply unfathomable.

There is a step learning curve , with many trips and false starts upon the way.  Once understood though, the benefits in code reuse and overall performance can be well worth the effort.   

Once you have understood the data flow functionality, then the hurdle of creating a UI will then have to be crossed.

Starting with a blank project , the end to end process will be demonstrated to allow you to get all the benefits. 
Presented by Dave Ballantyne at SQLBits VIII
  • Downloads
    Slide deck available Slide Deck 840 KB
    Samples available Zip File 4.4 MB
    Video available MP4 Video HD 459 MB
  • SpeakerBIO

    Dave is a freelance SQL Server database architect / designer / developer / consultant and lives near London, England.  He is a regular speaker at UK and European events and user groups and currently is supporting the London SQL community by organizing the "SQL Supper" user group.  He takes a keen interest in all things SQL and data related and is never happier than picking apart a poorly executing query.  He has also created an open sourced add-in for SQL Server data tools (SSDT) called "TSQL Smells".  This detects and reports on 'suspect'  code within a project and can be found at . Outside of work he is husband, father of 3 and exasperated archer.
  • Video