Calling Webservice from DTS

• Rashmin Amin

  Valued Member

  Points: 50

  More actions

  June 13, 2006 at 1:07 pm

  #94264

  I need to call a webservice from DTS, the webservice in turn returns a XML string.  Once I have the XML, I need to insert it into a table.

  My plan is to capture this XML in a DTS global variable and then call a stored proc to insert the XML in a table using openxml command.

  I am stuck at the point where I have the XML but I can not hold it in the DTS global string variable.  The XML is long string and it does not fit in the string variable.

  If anyone has another approach, that I can take OR another way to store a long string in the variable, I would appreaicate your help.

  Thanks.

• June 16, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Larry Garcia

  Newbie

  Points: 7

  More actions

  June 27, 2006 at 9:27 am

  #646091

  Can you post the code from the DTS package?