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 a Data Philosopher at Enterprise Data & Analytics, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer and BimlHero; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns, and author of Managing Geeks - A Journey of Leading by Doing, and the Stairway to Integration Services.

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 Companies

Community Awards

Friend of Red Gate

Contact Me


Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement