Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SSIS package to return XML data from Web Service and import to database

48 views
Skip to first unread message

Ckirby

unread,
Oct 26, 2009, 4:06:52 PM10/26/09
to
Can anyone point me to an example of how to setup an SSIS package that
would consume a webservice, stick the XML data into a variable, then
move that data into a table in SQL 2008?

I've got the web service task working properly (I think). The XML data
seems to be returned into the variable I've created, but then I get
stuck.

I'd like to avoid creating a file, just to read the file back in
before processing the data, but I'm not having any luck.

Here's the flow that I'm trying to acheive:

1. Call the webservice, put the XML data into a variable (Orders)
(this part seems to work).

2. Setup an XML task to translate the XML into 'regular' data , stick
in it a temp table , do some transforms/ data tasks on it, then send
it to the appropriate tables.

0 new messages