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