THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

PASS Summit 2008: SSIS Scripting

It's That Time of Year Again... 

I am honored to again be presenting at the PASS Summit! I'm even more honored to be co-presenting SSIS Scripting with Jessica Moss, SQL Server MVP!


Somewhere in the abstract for this presentation I listed the following three goals:

  • Explore SSIS Script Objects
  • Best practices for script coding
  • Demonstrate customized FTP class

I lied about the last bullet. Well, it isn't exactly a lie - I meant it when I wrote it (really I did). I've since thought of a better demo for bullet 3. It's _________!  No, there's no text there. It's top secret. Yes, Jessica knows, and no she won't tell either.

Is It Cool?

I think so. Cooler than a custom FTP class? I suppose that depends on how desperately you're in the market for some custom FTP code for SSIS (I was pretty desperate when I wrote it...). The new demo combines a few things I'm tinkering with lately - mostly as a hobby, but maybe as more than a hobby later. We'll see.

But getting back to the question at hand: Is it cool? I have one interesting idea per decade: This is my 2000 - 2009 interesting idea. I thought I was being unnecessarily giddy until I let Jessica in on the big secret. She thinks it's cool too. So there. At least two people on the planet think this is interesting stuff.


There's is a possibility (however remote), should you attend our session, you will disagree with Jessica's and my assessment of the demo code idea. If that's the case you should blame no one but me. Although Jessica is lending her superb Custom SSIS Task coding and presentation skills to our session, I talked her into writing a task based on my idea. If, on the other hand, you like the presentation and idea; you should give Jessica equal (or more) credit!

:{> Andy

Published Monday, November 10, 2008 1:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



New to SSIS Guy said:

It is so unfortunate that your very interesting and helpful presentation will never be available to people online. I would pay for a online video version of what you and Jessica are doing.

November 10, 2008 5:16 PM

andyleonard said:

Hi New to SSIS Guy,

  PASS records the sessions and sell the DVDs to attendees - at least they did last year. I'm not sure if it's available to anyone. Does anyone here know? I think it was around $100 last year and contained every session (not the pre-conference stuff though).

:{> Andy

November 10, 2008 5:31 PM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement