Presenting at Vancouver's PASS Chapter in July

A few weeks back Richard Baumet, the leader of my local PASS chapter, asked if I was interested in presenting something on SSIS in October.  I was just putting together some thoughts on topics when he realized his scheduled presentation to the chapter in July conflicted with another engagement.  He put out the emergency call, and since that night happened to be free for me, I offered to present.  Fortunately, Richard allowed me to do my presentation on SSIS - not FILESTREAM as he had been planning.  A win-win in my books - as I know nothing of it!  Hopefully the chapter thinks so as well, and I'm not left talking to crickets.
The Topic
I'll be doing a variation on a topic I presented at DevTeach/SQLTeach in June, and that I just happened to blog about recently.  It was well-received at the conference, but I still think I tried to cover too much - talking about custom tasks and data flow components.  (That does seem to be a problem for me!)  Since I already have those resources under my belt, I thought I'd stick my neck out a little bit further on this one..

Are you developing and supporting Integration Services packages? Five bucks says you have almost identical Script Tasks littered among your packages – they’re the “quick and easy” solution to a lot of common file handling, auditing, and other needs. But just like most “quick and easy” solutions, maintenance can quickly get out of hand – there’s no nice way to version Scripts, know which Scripts are “up to date”, or even know where a particular Script is being used so that you can update it. Every time you create a new package, you find yourself copying and pasting that same Script – and then modifying code and variable access to it. There is an alternative to that mess – Custom Tasks – and it’s really not as difficult as you might think.
Todd will lead you through the process of creating a Custom Task - turning your copy-paste-then-edit-script drudgery into drag-and-drop bliss. It’s no harder than the copy-paste-edit cycle you already go through – except you only have to do it once. In addition to finding out exactly how to do it yourself, Todd is inviting attendees (actual, virtual, or otherwise) to send in their favourite Script Task to be converted during the presentation! You could walk in to work tomorrow with a drag and drop solution for your Script maintenance nightmare...

What a deal!  You come for pizza, learn some stuff, AND go away with something you can take to the (time)bank!  I'll be trying to keep the opening slides to under ten minutes - hopefully that leaves enough time to get two or more custom Script Tasks built for attendees.  They'll all be available after the presentation - definitely on my SkyDrive, and maybe even on CodePlex in the handy SSIS Custom Tasks and Components directory.
When and Where
If you're in Vancouver on July 23rd, RSVP to Richard (rbaumet "@t" shaw.ca), and come to Sierra Systems' offices at 5:30.  The raucous party is on the 25th floor of 1177 West Hastings.  Pizza and drinks are being graciously provided by Idera and Sierra Systems.  (That reminds me that I have to try Idera's SharePoint toolset - SharePoint's built in backup/restore bites.)
Special Note!
I've just received the first snippet of code from a PASS member through Richard... and it's from a Script Component (a transformation), not a Script Task.  This presentation is about converting Script Tasks (on the Control Flow) to Custom Tasks.  Converting Script Components that work with columns in the Data Flow is a little more involved - I think too much for a short (if you think 1.5 hrs is short) presentation to do justice to.  So please - send Richard code from your Script Tasks...
Not to fear Sanjeev - I'll make some time before or after the "show" to step through converting your Script Component to a Custom Component.  You'll have a drag and drop component ready to go Friday morning...