Find Jobs
Hire Freelancers

XML - XML files into SQL database - SCRIPT, SSIS, SQL

$10-30 AUD

Closed
Posted about 8 years ago

$10-30 AUD

Paid on delivery
Hi there, I have a folder which contains multiple XML files. I need to develop a script to load these files into a SQL database. When the script is run it will load the most recent XML file into the SQL database, archive the XML file into a folder and repeat the process (loading the next XML file). Initially I was trying to build this package with SSIS and have had issues when processing multiple XMLs (as I couldn't define connection strings). I also have XML schema files. I want to avoid setting up a web service to process these XML files into the SQL database. I will install team viewer on my windows server which you can develop, test and complete the project. I can send examples of the XML schema and XML files.
Project ID: 9865230

About the project

32 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
32 freelancers are bidding on average $118 AUD for this job
User Avatar
Hello, I am very much interested to do this work by c#.net as i have strong knowledge in it as well as sql server & xml related works. Please send me the example xml files & schema. Thanks
$50 AUD in 2 days
5.0 (93 reviews)
6.1
6.1
User Avatar
hi, i am certified mssql server expert (mcse: data platform) with deep knowledge & experience in developing dts-&ssis-packages. would be glad to help you with this project
$250 AUD in 10 days
5.0 (22 reviews)
4.1
4.1
User Avatar
I will create ssis package for your requirement.
$50 AUD in 2 days
4.8 (12 reviews)
3.4
3.4
User Avatar
Hi, I am professional database/datawarehouse developer with 5+ years of expereance. If you want to share more about your project, feel free to contact. My bid is not fixed. Thank you.
$55 AUD in 1 day
5.0 (6 reviews)
3.3
3.3
User Avatar
I have done much work in XML, SQL and have used several database systems including MS SQL Server. I can design and develop a desktop based application in order to perform tasks of reading XML file and writing data to specific table of database system. I have done similar kind of work of managing the XML files with respect to tags and formatting the data in the files. Consider me for your this project. I will be waiting for your reply and some discussion about the related work. Thanks
$100 AUD in 4 days
5.0 (3 reviews)
3.1
3.1
User Avatar
I'm an Database Design and development with years of experience in large production environment. I've been working with MSSQL and MSBI as a Lead Developer and DB architect in several applications for different project. • MSSQL Server 2008 / 2012 • SSIS ,SSRS
$30 AUD in 1 day
5.0 (4 reviews)
2.8
2.8
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
5.0 (3 reviews)
2.6
2.6
User Avatar
Hi. I am an experienced .net developer and can do you task with C# and .NET. Always provide all source codes and support for project in future. Can create needed tools as command line or GUI application. Can i see examples of you XML files?
$30 AUD in 2 days
5.0 (3 reviews)
2.0
2.0
User Avatar
Hello More 20 years programming experience. I would like suggest small .net solution for you(assuming you are on windows), but I need more details to set real price and time. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$100 AUD in 5 days
5.0 (1 review)
2.0
2.0
User Avatar
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$15 AUD in 2 days
5.0 (1 review)
1.9
1.9
User Avatar
Dear Sir, I am having more than 12 years experience of working as a web developer and having a great exposure of website Development in C# and MSSQL. I believe in quality and client's satisfactions. I am planning to deploy a windows service in C# which will constantly watch the specified folder and do its process I am waiting for your most valuable conversations. Regards Ajoy
$66 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
as discussed, i understand the task and will do it. modifying my bid for the project XML - XML files into SQL database - SCRIPT, SSIS, SQL.
$50 AUD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have worked extensively on SQL programming. We can write a Stored procedure with bulk insert for all the xml files in SQL, which will insert the XML files (we need to create format file for processing xml files) into the DB. I will deliver the work with desired efficiency and speed. Please ping me for further discussions.
$30 AUD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Hello Sir/Madam, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the results that you have expected and we have already worked on a similar project before and can deliver as u have mentioned We are sure you will not be disappointed if you give us this opportunity. Our team is experienced, creative & efficient enough to get your job done well. We have an impeccable record and all our clients enjoy working with us, we are sure that you will too, our prices are cheapest in market. can u provide your email or sky-pe etc for further discussion about the project I am ready to discuss with you with best Regards
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I have great experience with data migration even optimization million files migration. So i have a question: what the count of files and what the allowable time running?
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can develop a SSIS package which can be easily deployed in your machine to import XML file into Database at scheduled time.
$25 AUD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I can make import from XML to SQL directly with single t-sql script that will be stored in DB as a stored procedure. 1) I need examples of xml-files first. 2) DB structure description (tables) and logic in which you need to upload xml-data to which tables. 3) I can develop and test script on my side.
$166 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an IT professional with an experience of more than 5 years. If given a chance would provide you the best solution at minimum cost. Thanks.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
1. Create connection string to the XML file path and to SQL Server database. 2. First we need check the XML files in the folder location. 3. If we have first we have get the latest file based on the Date. (if it is required process multiple files at a time, we can achieve with the help of For-Each loop ) 4. Process the latest XML file to SQL server DB. 5. Validate the xml data processed successfully in SQL Table. 6. Archive the XML file in the archive folder location. 7. Write log in the file or sql table location for tracking job. 8. Send e-mail notification to the users (If required).
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Malvern, Australia
5.0
48
Payment method verified
Member since Feb 6, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.