SSIS : Web Service task doesn't cut it but who cares
18 months ago I was trying to use the SSIS web service
task for a number of purposes. The first was to integrate with SalesForce, the
second was to manage reporting services. Unfortunately the Integration Services
(SSIS) web service task doesn't work for these web services. On further
investigation I'm not sure what web services it does support.
This was discussed in the MSDN forums http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=161653&SiteID=1 and
subsequently raised in connect https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126247
Well it's not going to be fixed in Katmai. You might wonder why I'm not
ranting about this not being fixed and how crap Microsoft are. Well I'm not
because of another enhancement in SSIS. I blogged about an associated change a
few weeks ago (SSIS
- Sweet sight - Visual Studio 2005 Tools For Applications). What this gives
is the ability to add references to your Script task, including web services.
That makes it very easy to use web services now in SSIS.
-