Hi,
I'm a DWH/ETL expert from Bulgaria (EU) with 8+ years of experience in that field.
Alternative approach is to use SSIS and to create a simple .aspx page that calls the package!
Relevant Skills and Experience
I'm proficient in wide variety of data tools:
1. ETL - SSIS, Pentaho Kettle, etc..
2. Databases - MySQL, MSSQL, PostgreSQL, Oracle, Teradata and a few others.
3. BI - Pentaho BI, SSAS, SSRS, PowerBI.
Proposed Milestones
R500 ZAR - M1: Create the db table for the data
R1000 ZAR - M2: Create a SSIS package that connects to the web service and loads the data
R500 ZAR - M3: Create a .asxp page that calls the package
What version of SQL Server do you use?