Vancouver PASS July: Presentation Slides and Demo Material

A huge thank you to Richard Baumet, Scott Stauffer, and the Vancouver PASS chapter for a great reception at the July meeting.  A big thanks to Sierra Systems for hosting, and Idera for sponsoring. 
I started off with the planned presentation - but it was apparent that the subject was a little too deep for the interest level of the audience, so we delved into other aspects of SSIS.  I did a little explanation of the SSIS architecture - Control Flow versus Data Flow - and what "things" were accomplished with each.  I explained (briefly) how the SSIS Data Flow was an in-memory "assembly line" as opposed to T-SQL "set" operations.  That topic led to questions about what kind of "real world" scenarios SSIS was intended for, and which scenarios should prompt you to look for some other tool.  That was followed by an explanation of why some operations (like sorting) were best left to other tools when possible - as those operations cause that "assembly line" to become inefficent and bottlenecked.  We covered a lot of ground - I hope it was an informational session for you!
A special shout-out to Sanjeev for "bringing your own code" to convert from a Script to a Custom SSIS object - I don't think you made it to the meeting, but send a message to Scott, Richard, or myself - I've got a DLL ready and waiting with your name on it...
Scott should have the meeting recording online soon at the Vancouver PASS website.  The (planned) slide deck about converting Tasks, and the conversion templates are all on my SkyDrive - feel free to download them.  For those of you interested in the "intro" part of the presentation, click though to my wrap-up post from April - the slides and a demo are there.
As I said at the meeting - I'll be trying out Idera's toolset for SharePoint to backup, move, and restore some SharePoint sites within the next week.  I'll try to post a comment here with info on how that went - but please bug me if you don't see that!
If you have any questions or comments about the process of converting Scripts, refer to my three part series for details and samples, and please don't hesitate to ask in the comments below, or on the MSDN SSIS forums.
Thanks for coming by for some Pizza and Integration Services - I'm sure I'll see you soon at a future Vancouver PASS meeting - hopefully listening to Richard talk about Filestreams and PHN BBQs...