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 Youtube 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 contact me here. UPDATE: The video is now available for download from my Live Folders space here: http://folders.live.com/self.aspx/VQ9oHa1TJjc/Public/BlogShare/20070619/Consuming%20Web%20Services%20in%20SSIS%202008/Consuming%20Web%20Services%20in%20SSIS%202008v2.zip UPDATE: The Live Folders team have updated their service and lo and behold none of my links work anymore. Here's the new link:
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 conenction.
-Jamie
UPDATE: 2008-10-22 - I've uploaded a version of this demp package that will work on the final release of SQL Server 2008. See here: http://cid-550f681dad532637.skydrive.live.com/self.aspx/Public/BlogShare/20070619/Consuming%20Web%20Services%20in%20SSIS%202008/ConsumingWebServices%7C_RTM.zip