THE SQL Server Blog Spot on the Web

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

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; 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 Managing Geeks - A Journey of Leading by Doing, and author of 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

Comments

 

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!

~Matt

September 18, 2008 11:49 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

News

Source Control 2.0 from Red Gate

My Company


Blog Roll


Check out the Linchpin People Blog...
Linchpin People Blog

Contact Me

Archives

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