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 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 AndyLeonard.blog.

My 2008 PASS Summit Sessions

This blog has moved! You can find this content at the following new location:

http://andyleonard.blog/2008/09/13/my-2008-pass-summit-sessions/

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

My Latest Book:

Community Awards



Friend of Red Gate

Contact Me

Archives

Privacy Statement