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.


John Spencer


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


Compétences : XML

en voir plus : xml sql, sql pdf files, sql pdf file, sql code pdf, remote typing, remote excel, index bit, how to get into writing, how to get cgi, bit index, xml files sql server ssis, sql microsoft access, mssql having, microsoft access sql, how to microsoft excel, xml to pdf, xml to my sql, xml excel, SSIS SQL, Sql ssis

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

Nº du projet : #1608152

4 freelance font une offre moyenne de $150 pour ce travail


Please check your inbox. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)

pl check pm

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)

Hi , I can do this task

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(4 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)