Find Jobs
Hire Freelancers

CSV to SQL Automated import

$30-250 USD

Cancelled
Posted almost 11 years ago

$30-250 USD

Paid on delivery
We get on a daily basis a csv file from our vendor containing product updates. It is delivered via ftp as a zip folder. In the zip is the csv file. I need some script that does the following to import/update into our SQL Server tables. SQL Server is 2012 Unzip original file Import/Update products from the table Confirm successfully updated Move zip file to backup folder so that when the new file is available the script is run against that one. Now it could be that the script will need to cross reference Product categories as well as they may not be the same as in the csv. E.g. In the csv file the product Major Category could be Small Business but in the SQL db the category would be SMB. So cross reference capabilities will be required.
Project ID: 4520034

About the project

5 proposals
Remote project
Active 11 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
5 freelancers are bidding on average $177 USD for this job
User Avatar
Lets Start
$147 USD in 3 days
4.9 (14 reviews)
4.8
4.8
User Avatar
Please check your PM
$155 USD in 3 days
5.0 (5 reviews)
3.0
3.0
User Avatar
I can do this in Java as a service that can be run on a windows machine.
$250 USD in 3 days
4.9 (6 reviews)
2.8
2.8
User Avatar
Hi. Check your PM please.
$133 USD in 3 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Sir I have good skills and +2 experience in MS SQL server. I can provide you this work in 3 days. Looking forward to work with you.
$200 USD in 3 days
2.4 (3 reviews)
1.9
1.9

About the client

Flag of NEW ZEALAND
Auckland, New Zealand
5.0
6
Payment method verified
Member since May 14, 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.