SQL 2008 SSIS Webservice Task: Post Data - SOAP 1.1 & 1.2

• sjr04

  SSC Enthusiast

  Points: 147

  More actions

  January 9, 2012 at 6:36 pm

  #391267

  Hello,

  I have a thousand rows of data (user demographic information) that I need to get into a 3rd party's SQL Database. I was fortunate enough to find the 3rd party company published a WSDL and I found their web service supports both the reading and writing of certain data to the db. Unfortunately, all the SSIS examples I found detail the extracting of data from a xml web source, after passing a variable to the service, but not the posting large quantities of data to a web service.

  From what I gather on the extraction of large quantities from a web service the SSIS package will have the following:

  1. Web Service Task

  2. Data Flow Task

  3. Foreach Loop

  Can anyone detail how to post data (multiple rows of data in a spreadsheet) to a web service? The web service is expecting a string.

  Thanks in advance!

  PS: to anyone who answers, this will be the only example this process using SSIS that is out there (okay okay.... maybe I missed one)

• sjr04

  SSC Enthusiast

  Points: 147

  More actions

  January 9, 2012 at 9:28 pm

  #1430885

  The closest example to solving the problem I have seen: http://learnbycoding.com/2011/07/ssis-web-service-task-by-downloading-wsdl-to-temp-folder/#.Twu9E6W0yYs

  Enjoy!