December 17, 2013 at 2:08 am
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
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
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
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
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply