SSIS: Consuming web services in SSIS 2008
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.