Post reply

Calling Webservice from DTS

  • 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

  • June 27, 2006 at 9:27 am

    #646091

    Can you post the code from the DTS package?

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply