Post reply

Web Services Task transformations

  • 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

  • October 24, 2008 at 3:21 pm

    #889514

    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/

  • January 14, 2010 at 9:33 am

    #1103722

    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

  • January 14, 2010 at 9:52 am

    #1103744

    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/

  • January 14, 2010 at 11:50 am

    #1103830

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

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

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