Classic ASP - Download XML from link and upload to SQL Server

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I have a list that is available to me in XML format through a download link. I need a classic ASP function written to loop through the file and insert that xml file into SQL Server. There's only 7 fields that are in the file that need to be inserted into SQL. The table name in sql server will always remain the same and can be hard code d into the function.

Exmple:

FUNCTION DoXmlToSQL

'Download file from web server

'delete all records from tmp table in sql

'loop through file

'insert records into SQL

'confirm same number of records now in Sql table that were in XML

END FUNCTION

I need this done asap.

I will provide you with the XML file but not the download link as it's from a secure server. I can not provide you with SQL Server credentials. You either test with your own Sql Server or you provide the file and I'll test on my end.

ASP SQL

Project ID: #12800468

About the project

29 proposals Remote project Active 7 years ago

Awarded to:

htiwary

Hi, If u want to do this in asp it will take me around 2-3 hours but if didn't care about the language then i have a ready made on the shelf ready solution in vb 6.0 . You can test it immediately only you have to pr More

$150 USD in 3 days
(1 Review)
2.4

29 freelancers are bidding on average $170 for this job

sumon355

Hello, I am basically expert in SQL(mostly ms sql server), but i have also good experience working with classic asp as well as xml. I understand your requirements and i can do it. Looking forward to have a positive re More

$144 USD in 3 days
(274 Reviews)
8.0
ITservice

Hi, I have done the similar task of importin data from xml and inserting to SQL. Send the xml file, will work on my server and demonstrate the functionality. Regards

$111 USD in 2 days
(267 Reviews)
8.1
aanvikm

Hello Sir, I am an excellent classic ASP developer and would like to work on this project. I have done similar in past and I am 100% sure I should be able to do this as well. Thanks Aanvik

$277 USD in 3 days
(42 Reviews)
6.8
jagdishbhatt38

I am having more than 7 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili More

$200 USD in 3 days
(36 Reviews)
5.2
gangabass

I'm Classic ASP developer with hundreds of excellent reviews here that's why I'm sure you'll be impressed with my work. I can create function you want but I need to get more details from you. First of all I'll need More

$155 USD in 2 days
(42 Reviews)
5.5
rsajwan

Hi , I have 12+ years of Classic ASP exp. I can help you in this. I would like to discuss this opportunity with you. My skype id is "rpsajwan". Please let me know your reply. Thanks With Regards

$100 USD in 3 days
(30 Reviews)
4.9
hatimtaj

Hi - approximately how many records do you anticipate in the XML file? Also, I'd appreciate if you could please share an XML with some sample records so I have a better idea about the data. Thanks, Hatim

$90 USD in 3 days
(10 Reviews)
4.5
yubor

A proposal has not yet been provided

$155 USD in 3 days
(19 Reviews)
4.1
narendragautam

Hi, I can do this in classic asp. Thanks Narendra

$150 USD in 3 days
(3 Reviews)
3.9
vw7590795vw

Please review my profile. I have 7.1 years experience in SQL Server. Please let me know more details and when we will start.

$105 USD in 10 days
(21 Reviews)
4.0
mobiletech1604

Dear sir Thank you for posting this project. I could start now and let it done ASAP. I'm concern about step delete all records from tmp table in sql. Did it in need? Since we don't save anything in tmp table. Let me More

$211 USD in 0 days
(4 Reviews)
3.6
dhanaselvam

hi , I am a .net developer i have worked with sql sever and asp.net through c# or VB. So i can develop the functionality for you. Inbox me to discuss in detail

$67 USD in 1 day
(1 Review)
1.6
amirgull

Hello sir, I have vast experience of building applications on Asp, Hope you look forward to work with me. Thanks!

$100 USD in 3 days
(2 Reviews)
1.3
dolfuz

Sure! I will love to help you with this one :) If you have any question to know I'm the right one feel free to contact me. Thank you for your time.

$166 USD in 5 days
(0 Reviews)
0.0
SAMASYS

Hi I already started in your code I read the XML file and now working in the second part I tested with the attached file I believe I can finish your code this night Just please send me your XML file to test with More

$111 USD in 1 day
(0 Reviews)
0.0
TestingLeaders

This is a simple job. I have very good experience sql server and xml. Will do this greatly. you dont need to worry about any thing. Thanks Highly experienced and seasoned MySQL Developer with a proven record of str More

$55 USD in 2 days
(0 Reviews)
0.0
fcppsoft0

Hello. I have working solution

$111 USD in 2 days
(0 Reviews)
0.0
mandavcon

Hello With 6 years of application development experience I would like to offer my services for this job. I have very good strong experience in .net technologies and worked on wide range of small to enterprise lev More

$155 USD in 3 days
(0 Reviews)
0.0
OMNNICalifornia

I have Masters from New York, am based in San Jose, California and have recently completed a similar project for parsing/importing XML data for a client. Been in the industry for more than 10 years. Hari Om

$199 USD in 2 days
(0 Reviews)
0.0