Post reply

Webservice as A Data source

  • December 17, 2013 at 2:08 am

    #280444

    Hi All

    I have a requirement like My source is webservice from which I need to Pull Data and put it into MS Dyamics CRM Data base .Can any one give a rough figure how to obtain this ? Firstly I need to Know how to get data from Webservice using SSIS Please help me in this regard

  • December 17, 2013 at 10:27 am

    #1674166

    I found that using the script task when using a web service to get data works the best. You will need to reference the web service from your script and use whatever web methods are provided.

  • December 19, 2013 at 10:56 pm

    #1675045

    HI

    There is something like webservice task in SSIS . IF o/p of webservice is row in a table.Is it possible to store it in a variable.If so then how to get the column values of it for further usage

  • December 20, 2013 at 12:06 am

    #1675056

    Karen A. Ferrara-426245 (12/17/2013)

    I found that using the script task when using a web service to get data works the best. You will need to reference the web service from your script and use whatever web methods are provided.

    Using a Script Component (not Script Task) as a data source in a data flow is one way we do it.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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