Post reply

Web service to output variable

  • June 30, 2008 at 4:11 am

    #122941

    dear listers,

    I'd like to export a resultset of a webservice to an output variable , and re-use it as data sorce.

    Do you think is it possibile in SSIS?

    Thanks in advance

    Cris

  • June 30, 2008 at 8:54 am

    #836182

    It seems like it ought to be possible, though I've never done it.

    I would look at the Recordset destination if I were you. It takes a var (object data type) and you can use that as a source in many other transforms.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • July 2, 2008 at 7:43 am

    #837235

    thanks crever, I'll try your solution 😉

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

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