Bringing web service data into SQL server
4
votes
1
answer
3343
views
I need to retrieve a data set daily from a hosted Web service. I can retrieve the XML "column names" in an SSIS package. But I need to retrieve all the data in the data set in csv format or bring directly into SQL Server. (Rows and columns, header data and dataset).
Is this feasible on SSIS? Or is there a better approach? Any input or advice is greatly appreciated.
Asked by William M Low
(41 rep)
Sep 10, 2016, 02:23 PM
Last activity: Feb 21, 2020, 08:18 AM
Last activity: Feb 21, 2020, 08:18 AM