sql server - SSIS-Calling java service using Script Task -


i trying call java base web service method writing following code in script task's entry point method. following code executing if call console application while calling ssis control flow, upto message box 1 executed on executing webrequest.getresponse() happen dont know neither gives error nor execute next line of code.

    public void main()     {         string envelopecontent = getsoapevvelope();         xmldocument soapenvelopexml = new xmldocument();         soapenvelopexml.loadxml(envelopecontent);         httpwebrequest webrequest = (httpwebrequest)webrequest.create(_url);         webrequest.method = "post"; // executed         soapenvelopexml.save(webrequest.getrequeststream());         messagebox.show("1");          webresponse response = webrequest.getresponse();         messagebox.show("2"); // not executed         string responsestring = string.empty;         using (var reader = new streamreader(response.getresponsestream()))         {             responsestring = reader.readtoend();         }          xmldocument doc = new xmldocument();         doc.loadxml(responsestring);         xmlnode node = doc.selectsinglenode("//*[local-name()='result']");        } 

please guide me do? per understanding web service task require wsdl/proxy. there other way call java base web service passing soap envelope in request?

thanks

@paul

i experienced while using sql server 2008 r2. have tried same solution in sql server 2012 , working fine out changes.


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -