I'm looking for a script or compiled (vb.net only) with source code that will process and XML file and write the records to a SQL 2008 database.
I have already created the tables (4) and have the connection info ready. Your code will open the xml file (sample attached) and based on the parent node in XML, will write the values to the columns in the database. There are four tables.
I may run this script daily and the report may have same data so your script/exe will need do a lookup and find if the record already exists in the database. You can do this by a lookup on certain fields Example for Items Ordered it would be ASIN, Tag, and Date.
This is pretty straight forward and simple for someone that knows how to parse XML files and write to a database.
25 freelancers are bidding on average $109 for this job
I have more than 6+ years of experience as VB.Net / SQL [url removed, login to view] start the work to finish it professionally and within [url removed, login to view] of work provided upon request.