Dave Ballantyne
clearskysql.co.uk
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.
SQLBits 2011
SSIS Custom Components
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
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