Home Forums Data Warehousing Integration Services XML from RESTful web service into SQL table(s) using SSIS RE: XML from RESTful web service into SQL table(s) using SSIS
noober
Valued Member
Points: 71
More actions
May 24, 2013 at 8:25 pm
#1618500
Instead of writing it to a file and then using an xml source...why not just do everything in a script component? You can call the web service, de-serialize the xml and add it to your data flow...I have a step by step example here: