XML import to SQL

Closed

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.

Skills: Database Administration, Script Install, Shell Script, Windows Desktop

See more: xml import sql, sql pdf files, sql pdf file, xml to pdf, sql import, Sql 2012, PDF to XML, open xml, import sql, sql created, column already exists, web data table extract, xml extract pdf, sql create script, sql view table, script xml file sql, download import download, script sql table, extract xml pdf, load data xml, load data xml file, windows xml file, import xml files, import import, xml file import sql

Project ID: #2735743

Awarded to:

mastirlaa

See private message.

$200.6 USD in 25 days
(47 Reviews)
5.9

20 freelancers are bidding on average $192 for this job

mhmhz

See private message.

$255 USD in 25 days
(136 Reviews)
6.5
bob1982

See private message.

$255 USD in 25 days
(185 Reviews)
6.3
quickprogexpert

See private message.

$255 USD in 25 days
(119 Reviews)
6.0
medsoftngo

See private message.

$170 USD in 25 days
(21 Reviews)
5.1
pipalhub

See private message.

$255 USD in 25 days
(20 Reviews)
4.5
MAdept

See private message.

$255 USD in 25 days
(6 Reviews)
4.4
ysrahmed

See private message.

$210 USD in 25 days
(18 Reviews)
4.2
indianpws

See private message.

$150 USD in 25 days
(4 Reviews)
4.0
sergeybarseghyan

See private message.

$85 USD in 25 days
(18 Reviews)
3.8
olsoft

See private message.

$100.3 USD in 25 days
(11 Reviews)
3.6
ragastens

See private message.

$255 USD in 25 days
(10 Reviews)
3.6
dekravw

See private message.

$175.1 USD in 25 days
(6 Reviews)
3.2
nithyarajeshg

See private message.

$153 USD in 25 days
(13 Reviews)
2.1
szuge

See private message.

$250 USD in 25 days
(7 Reviews)
2.0
DaveWM

See private message.

$40.8 USD in 25 days
(1 Review)
1.6
ArsenMkrt

See private message.

$170 USD in 25 days
(4 Reviews)
1.3
renjithgnair

See private message.

$250.75 USD in 25 days
(1 Review)
0.8
VorpalSword

See private message.

$153 USD in 25 days
(0 Reviews)
0.0
manojks029

See private message.

$200.6 USD in 25 days
(0 Reviews)
0.0