Jamie Thomson

Thoughts, about stuff

SSIS: Consuming web services in SSIS 2008

leave a comment »

SQL Server Integration Services (SSIS) 2008 is bringing with it new capabilities. One of the biggest new features is the new scripting engine. Previously Visual Studio Tools for Applications (VSA) was used as the scripting engine but that has now been superceded by Visual Studio Tools for Applications (VSTA).

In the video below I demonstrate some of the capabilities of VSTA within SSIS 2008. Specifically, I show how easy it now is to work with web services from right inside the SSIS pipeline. The video may not show up in some blog readers in which case head here to watch it.

The video has lost a bit of fidelity when uploaded to Soapbox due to them shrinking it. I tried to attach the original version to this blog entry but unfortunately our blogging engine (Community Server) rejected the file for being too large (its 5.5MB). If you would like a copy of the video emailing to you then please feel free to send me a message.

Thanks to my colleague and drinking buddy Andy Britcliffe who helped me out with some of the code.

Attached to this blog entry is the package that I built while recording the video. You don’t need to do any configuration in order to execute the package, you just need to have an internet connection.



Written by Jamiet

June 20, 2007 at 12:59 am

Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: