load xml files from ftp site into sql server tables


windows 2012 server

ms sql server


some sort of script to run the process


-access ftp folder (at moment over 7000 files there)

-read xml files (named .001 for some reason) in sequentially in order of creation date and obtain file name (samples attached)

-files have many names, need to look inside to see if one of 2 xml formats, to load two sql server tables will be loaded KAARTEN and VERZILVERING, sql attached.

- basic rule: kaarten / activation are xml type table KAARTEN redemption / verzilvering are table VERZILVERING there can also be empty files

-note date/datetime fields are varchar(25) and added field import_date to be timestamp of when it is loaded.

-for tables, sql used attached,

-I imagined another table in sql server that would place timestamp of creation date of last file process, then next time it runs it will check after certain timestamp. Or we can place this is a flat file somewhere… open to suggestion here. this script should run often, maybe every 15 minutes.

- Note, I have triggers that run on insert into each of the 2 tables, hope there is no problem with this.

attached: sample xml, sql to create 2 tables, php scripts attached FOR REFERENCE created in phase one of project when thought we were on mysql. these could be used as basis, or someone can tell me if php runs on windows? in php version: tables ID, we can add if necessary, php version also does not have correct datatype for date fields. [login to view URL] has file names of files in ftp directory as of friday

Beceriler: SQL, XML

Daha fazlasını gör: sql server export excel ftp, sql server 2008 file ftp, sql server ecommerce site, ado sql server tables access 2007, insert xml data sql server tables vb net, insert xml files tables sql server, insert xml files sql server, import xml files sql server 2005, dot net nuke access sql server tables, load binary files sql server, script modify sql server tables, sql server parent child tree xml, insert xml sql server tables net, sql server reporting services ftp, xml files sql server vbnet

İşveren Hakkında:
( 5 değerlendirme ) Amsterdam, Netherlands

Proje NO: #13419561



I have worked on exactly the same project before (load XML into SQL Server) that's why I'm sure you'll be impressed with my work. I can create such script according to your need in less than two days and I can offer Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 100%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(60 Değerlendirme)

Bu iş için 13 freelancer ortalamada $161 teklif veriyor


Hello there I know how to connect to ftp and read files and populate the sql server using php. I can do this project as per the rules outlined in your project. Looking forward to work with you. Thanks Rinsad

in %bids___i_period_sub_35% gün içinde157%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(122 Değerlendirme)

Hi, I have read your requirement and ready to start work on it. I couldn't find the table script files though. I will build and exe file which we can then put into schedular (if you have dedicated server) or we Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)

HI Contact me for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(37 Değerlendirme)

I am 9+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

As description in your requirement. I'm sure to complete this tool for you. inbox me if you have any question about my skill or this project. Thank for your attention HuyPQ.

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

I am production support database Administrator/Architect with 15+ years of experience . I have worked on FTP scripts/ automated import into database using scripts. I have worked year long implementation plus 24 x Daha Fazla

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Hi, Greetings... I can load xml files from ftp site into sql server tables.I have good experience in this field and definitely meet your requirements.I will give you 100% quality [login to view URL] have a look at my Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, CONTACT US FOR OUR PREVIOUS WORK PLEASE HAVE A LOOK INTO MY PORTFOLIO NiGELLA SOFTWARES is very interested in your job post as we are having related work experience in fulfilling the need for the job posted an Daha Fazla

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello sir!! Myself Sumit Singh, I read the job details extremely carefully and I am absolutely sure that I can do the project very well.I have experience more than 8+ yrs. My skills are : - PHP, MySql,Python MVC Frame Daha Fazla

in %bids___i_period_sub_35% gün içinde251%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)