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 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