My 2008 PASS Summit Sessions

I am honored to be selected to present at the 2008 PASS Summit!

I’m presenting two sessions: Test-Driven Development For Database Professionals and SSIS Scripting. I’ve been working on the presentations recently and realize there will be a few minutes left in the SSIS Scripting talk unless I talk slow. (Some people say I talk slow enough already – and that I have a Southern accent. Can you believe it?)

Anyway, I open the floor to you good people – the readers of my blog: What cool (or useful, or challenging) SSIS Scripting demo would you like to see? We’ll make it a contest. Leave a comment here (keep in mind I moderate comments so they will not appear automatically) and I’ll pick one.

I’ll have to come up with some cool gift to award the winner.

:{> Andy

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>

One thought on “My 2008 PASS Summit Sessions

  1. Hey Andy!
    I just did a scripting presentation for the SSWUG.ORG virtual conference. Assuming you’re talking about 2008, here are some ideas:
    1. Show how VSTA makes it easier to reference web services
    2. Re-use functionality by isolating your core logic in an external assembly
    3. While you can’t step through a script component in a debugger, you can debug the code if it’s in an external assembly
    – load the assembly project code in VS
    – set the debug executable to run your package with dtexec.exe
    – set break points in your code
    – voila!
    4. Talk about when it’s more appropriate to use custom tasks/components instead of scripts (which was the topic of my sswug presentation)
    Hope that helps!
    ~Matt

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.