Louis Capece
asked on
SSIS call web API with script task in VB.net
Hello:
I need to callthe following API, retrieve the XML results so they can be written to a SQL server table. The API is http://data.fcc.gov/api/block/2010/find?latitude=40.0&longitude=-85
I need to callthe following API, retrieve the XML results so they can be written to a SQL server table. The API is http://data.fcc.gov/api/block/2010/find?latitude=40.0&longitude=-85
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for this! Hopefully, this will help alot of others. Great examples and code
which SQL Server version?
Which coding language (for newer SSIS versions you have the choice between VB.NET and C#)?
Thanks.
Rainer