We have the need to capture data from several XML files to associated tables in MS SQL server (2005+).
VB.NET 2008 or 2010 is required for this project.
You will receive sample XML and associated XSD documents as well as MS SQL table layouts. However, you may be required to create additional tables from the XML schema as deemed necessary.
For this project, there will be 5 XML files to be processed.
If you need additional information, please let me know
Thanks
Bill
Update:
Sample XML files uploaded
## Deliverables
Attached are 4 XML files. The file [login to view URL] will require up to 3 or 4 MS SQL tables to hold the data. To simplify the project, I would ask you to create the corresponding tables as needed.
XML schema (XSD) will be available for the winner upon request.
* * *This broadcast message was sent to all bidders on Thursday Oct 4, 2012 5:59:39 PM:
I just updated the project to include 4 sample XML documents. If you need to adjust your bid, please let me know. Thanks Bill
10/05/2012:
Adding 6 sql scripts for tables to be used with the XML import.
* * *This broadcast message was sent to all bidders on Friday Oct 5, 2012 12:24:31 PM:
Per request, I've just uploaded the SQL scripts for the associated XML files. Please note that there are 3 tables associated with [login to view URL] . They are not necessarily complete, but you can use it. I would suggest to use an Identity column to identify records generate from the same XML file. Feel free to modify the tables to make it work properly. All XML files are assumed to be available in a local folder, so you don't have to worry about how and where to pick them up. You can create a test database to hold the table. Thanks Bill