This should be a simple little project for someone.
The BOM website provides a JSON feed of the data I need. Here it is:
[url removed, login to view]
I need a script to fetch this data and insert it into my MS SQL 2008 database. The script will run via Windows Server 2008 Task Scheduler once per day.
My database has columns like: city, temperature, wind speed, direction, pressure, rain
16 freelancers are bidding on average $74 for this job
Hi, This can be achieved by first downloading this JSON data and then insert data in SQL Server by creating a Console application in C#. I have 7 years experience in C# and SQL Sever
12 years of experience with SQL Server and data migration / feed-based import using everything from manual scripting to Integration Services to ORM mapping.