Download the slides and sample code from the Extending SSIS with Custom Tasks presentation, presented by Darren Green, at the SQLBits 2007 Community Conference.

The sample demonstrates a custom task with a connection property, including a property grid drop-down (UITypeEditor), and a password property flagged as sensitive to honour the package protection level. It also illustrates how to create a user interface for your task.

Session abstract-

This session is all about developing for SSIS, writing .Net code to create your own tasks. We cover by way of introduction the different component types you can develop, and the common approach you can use. We will walk through examples of task development highlighting best practice and lessons learned. You will also find out how to create user interfaces and interact with the SSIS design-time environment for a rich user experience. As well as getting real-world insights into developing for SSIS, you will learn the practicalities of installing and managing components.

Extending SSIS with Custom Tasks.zip (212KB)