SSIS Webservice Task : SOAP HEADER REQUIRED
Hi I would like to extract some data in using a webservice task from SSIS 2008 R2 from a httpConnection and a wsdl file... Until now No Pb, I see the service and the suggested methods... Then When i run the task a pretty error message indicates "SOAP HEADER REQUIRED" ! Where could i fill in the necessary GUID, security key, ID... in the header ? Shall i write a script before in a script task ? Has Anyone got an example ? Please help :-) ? Gilles
August 24th, 2012 9:57am

Hi Gilles, Yes, a preprocessing with a Script Task would be necessary I trust this thread has the full answer http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/695ff2ec-1090-4da9-9ec3-36fc84cce13b/Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2012 10:12am

The WebService Task is good for simple web calls. For better control over your webservice invocation I would advise you to use a script component as a source and marshall your invocation logic in a .Net code. There are loads of reference material available on the web on how to invoke a web service via a SSIS script component.http://btsbee.wordpress.com/
August 24th, 2012 10:20am

Thx Arthur I saw the thread before asking the question because I don't have the book ...
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2012 10:50am

Any idea on where... I don't have the necessary skills to write .net code in the script I just need to inform about GUID, security key, id product in the header then the general, input and output properties that we can see in the WS task Thx
August 24th, 2012 10:59am

Refer this where the author gives a step-by-step representation of how to consume services using a script component (ignore the first 2 step as it talks about hosting a service). "Add Web Reference" (.Net 2.0) or "Add Service Reference" (.Net 3.5) will allow you to connect to a hosted web-service or a wsdl. Once you do that you can set any property on the outgoing request message.http://btsbee.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2012 11:48am

Thx a lot btsbee, it s probably the best answer Unfortunately i don t have the required tool to test it (WCF Service application) Thx Again Gilles
August 30th, 2012 9:10am

Hi BTSBEE, I could set up the Ultimate VS2010 version and can from now continue to progress with yours advices below. Why do i have to ignore the first two steps ? I thought to have to create in first, my own service to call the other webservice How to set up the header parameters from this solution ? Gilles
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2012 4:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics