CSV to MS SQL Script for import
$15-25 USD / godzinę
We get each night a csv file from our vendor. The headings do not match our heading in the SQL table. We want a script that will map csv headings to the SQL headings then import,update each product accordingly. Ideally we would like this to run automatically each night at a predefined time.
We have set this to hourly because we want to be able to call on you as we find further requirements or modifications. There may well be plenty more work if you are go.
Numer ID Projektu: #6958126
O projekcie
22 freelancerów złożyło ofertę na średnią kwotę $19/godzinę w tym projekcie
Hello, Hope you are doing good. I have read your requirements and I have done similar work many times. Also you can see my last project was same automated process. I think instead of do at only on SQL server import Więcej
Hello Sir, Greeting for the day, Hope you are doing well I am Working with Data Center Organization as a Software Support Engineer, I have more than 8 years’ experience in Windows/Linux Server administration , Websi Więcej
Dear Sir, I have read your Project description & understand that why you have posted this project hourly, so can I see the CSV file? Please drop me a message thru' Freelancer PMB, if you're interested in our Company Więcej
The project can be build in Sql server and also I can create package which can be scheduled in Sql server. I have worked on project similar to this where I have created SSIS package to load CSV file data into S Więcej
Experience Around 3 years of experience in Microsoft SQL Server and Oracle Plan We can have a simple stored procedure to run daily which will automatically process the CSV file and move and update the required ta Więcej
Hello, I have 2 years of experience in Sql Server. I currently working as DBA. I can create script and help you to run it by schedule. Artem.
Good Day. VSoftware is a software development provider. SQL Server has a tool called BCP, which could be used to read csv files. Please check VSoftware profile. Thanks.
Hi, Mapping heading of CSV to SQL table is not much tough. On the other hand if you want to run automatically, then you can create a service program with a scheduler which does this for you. I can make a scheduler ser Więcej
I already programmed an script very similar to this one, I should do only minors changes to cover all the current project specifications, the script will be written in pure SQL and it will be launched automatically at Więcej
Hello Employer, I am Rana Bharat here.i am working as a software developer in ahmedabad, india. i have very well experienced in developing customized application like, payroll, invoice, pos and others. i know what Więcej
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor Więcej
Dear Client Hope that you are doing well. We have 5+ years experience in WPF,WINFORMS,C# , MS SQL SERVER and Desktop Applications. We have developed many desktop applications in c#, WPF,WINFORMS and MS SQL SERVER. Więcej
Hi! Creating MS SQL script is a usual task. I will provide you with the solution you need. I have some questions about this task: 1. Is there any description of field name matches from CSV and your table (f.e.: Więcej