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
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