XML import to SQL

This project was successfully completed by mastirlaa for $200.6 USD in 25 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$100 - $300 USD
Completed In
25 days
Total Bids
Project Description

I have a web site that I connect to every day and manually download a zip file from. This file contains a PDF and XML. I download these files to a directory and then import the XML sheet into SQL 2008 R2.

I would like a program that can connect to this web site every day and down load these files and then import into SQL.

The program needs to be able to extract the XML sheet from the ZIP file, open it and view the keys.

If the primary key exists in SQL as a table, import the other keys into columns. If it does not exist it should create the table and then import. As it finds keys though out the XML sheet, other than the primary key, that do not already have columns created, it will create the column. If the column does exist it will simply import the data.

This program also needs to be able to not import the XML if it already exists in the data base.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online