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

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

Published Saturday, September 13, 2008 5:05 PM 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



Matt Masson said:

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!


September 18, 2008 11:49 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement