Fermé

XML to sql UPDATED DESCRIPTION

Hi I have a couple of large xml files that I would like to get into my sql database.

They are both around 300 mb in size and I cannot figure out how to get these imported,

one of the files also has a daily update file which is only around 4 - 5 mb which I also need importing into my mssql DB.

I basicly need some code or sql writing to import the big files once and the daily file daily...

I can provide remote desktop access to the server if needed.

Thanks

John Spencer

UPDATE

Apologies guys I always rush when typing all the details.

I meant My own SQL Database

I am running localy microsoft sql 2008 server

I have tried to import the files using ssis but am having a bit of trouble, In the past I have just converted the smaller XML files to csv via excel then imported in ssis as I know how to do this, but with the XML directly to my SQL database I am struggling a bit.

The files if anyone want to have a look at them are

[url removed, login to view]

[url removed, login to view]

and the smaller one is

[url removed, login to view]

this is the one I need adding to [url removed, login to view] 's table/tables daily.

There is a pdf detailing the files and their locations located at

[url removed, login to view]

Thanks again

john.

Compétences : XML

Voir plus : xml sql, sql pdf files, sql code pdf, remote typing, remote excel, index bit, get cgi, bit index, sql microsoft access, mssql having, microsoft access sql, xml excel, ssis sql, sql ssis, sql server ssis, sql server 2012 ssis, sql microsoft, sql code, sql access, sql 2012, pdf xml, icecat, gz, excel rush, database microsoft sql

Concernant l'employeur :
( 2 commentaires ) Milton Keynes, United Kingdom

N° du projet : #1608152

4 freelance ont fait une offre moyenne de 150 $ pour ce travail

samitXI

Please check your inbox. Thanks

200 $ USD en 5 jours
(1 Commentaire)
3.6
aoefmpes

pl check pm

100 $ USD en 3 jours
(3 Commentaires)
3.1
vishweb

Hi , I can do this task

200 $ USD en 10 jours
(4 Commentaires)
2.3
gcmishra

This can be easily done using XML parser program that I have written Java. I can reuse the code and deliver fast result.

100 $ USD en 3 jours
(0 Commentaires)
0.0