Web Services Task transformations

Question

Web Services Task transformations

fthornton

Grasshopper

Points: 19
More actions
October 17, 2008 at 11:27 am

#123946

What i've done is taken a dataset from a web service stored it into a variable and passed the variable to a script task that creates a DataSet object
What I need to do is call this web service that provides a list of names an email addresses and update a table in a database. Any assitance however big or small is appreciated.
Fred

Viewing 5 posts - 1 through 4 (of 4 total)

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

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

Fred,

Instead of creating DataSet object (which is not very useful in SSIS), you should create SSIS script source component and implement your web service calling logic in it. Then push directly the data in the the data flow pipeline and process and update your destination appropriately.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

RJ-389260 Grasshopper Points: 17 More actions · Answer 2

Hi CozyRoc,

Your scenario is exactly what I am trying to accomplish. Do you know of any references where I can get more detail about how to accomplish this? Thanks

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

RJ-389260 (1/14/2010)
Hi CozyRoc,
Your scenario is exactly what I am trying to accomplish. Do you know of any references where I can get more detail about how to accomplish this? Thanks

I don't have anything on hand for web services, but you may check the RSS Source script, which retrieves data from RSS link and provides the information in data flow.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

RJ-389260 Grasshopper Points: 17 More actions · Answer 4

Thanks Cozy...that will get me going in the right direction.