Hi,

From a SSIS package, I want to query a web service, which retuns a xml
string (nothing but ds.getXml() ), and then load this data into a sql server
table.

So I want to save the web service output to a variable and use the variable
for XML source adaptor. But I am facing some problems.

I first tried saving the webservice output to a file and creating the xsd, I
am not getting the column in the XSD. I checked the output xml file. If I
open teh xml file using a browser, it is perfect.

Can anyone help me how do I solve this problem.

Regards,
Butchi Satuluri

I need to read the data from a web service (which basically returns
ds.getxml()), save the data into a variable and later use this as xml source


Regards,
Butchi Satuluri