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
Post a Comment