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