Webservice as A Data source

  • 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

  • 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.

  • 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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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