You have chosen to sponsor your bid up to a maximum amount of .
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.