CSV to MS SQL Script for import

Ukończone Opublikowano Jan 9, 2015 Płatność przy odbiorze
Ukończone

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.

Microsoft SQL Serwer

Numer ID Projektu: #6958126

O projekcie

22 ofert Zdalny projekt Aktywny Jan 10, 2015

Przyznany użytkownikowi:

mpalgeo

Hello My proposal is this I will make a script to import the csv file into a stage table in the DB. After the success import I will make all the necessary updates. Final after the correct completion of the Więcej

$15 USD / godzina
(64 ocen)
6.0

22 freelancerów złożyło ofertę na średnią kwotę $19/godzinę w tym projekcie

developer0106

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

$17 USD / godzina
(73 Oceny)
7.7
karunakartiwari

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

$22 USD / godzina
(33 Oceny)
6.3
leadconcept

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

$26 USD / godzina
(1 Ocena)
4.7
zcavar

Hi, I am working as Lead Consultant at the Daimler EDC (European Data Center) in Stuttgart, Germany. My responsibilities include 3rd Level Support for SQL Server, SharePoint and IIS, for more than 150 projects. - I Więcej

$33 USD / godzina
(1 Ocena)
2.4
avneetkaur21

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

$22 USD / godzina
(0 Oceny)
0.0
balamurugan1990

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

$21 USD / godzina
(0 Oceny)
0.0
AnyKey45

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.

$20 USD / godzina
(0 Oceny)
0.0
ldmarv256

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.

$20 USD / godzina
(0 Oceny)
0.0
subhapraves

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

$16 USD / godzina
(0 Oceny)
0.0
nemudriy

A proposal has not yet been provided

$22 USD / godzina
(0 Oceny)
0.0
mijailsosa

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

$15 USD / godzina
(0 Oceny)
0.0
audelk

hi sir, im full time freelancer. im very interested with hour project, i have expertise in ms sql and DBMS as a whole. im looking for long term working partnership, so i have no problem if you need more requirements, y Więcej

$15 USD / godzina
(0 Oceny)
0.0
gperete

Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office. we can adjust the hours per week according to your needs. i plan to create a visual basic program for Więcej

$15 USD / godzina
(0 Oceny)
0.0
suratsoftware

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

$15 USD / godzina
(0 Oceny)
0.0
toinnisfree

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

$20 USD / godzina
(0 Oceny)
0.0
kusinfonetcom

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

$15 USD / godzina
(0 Oceny)
0.0
JVinod

A proposal has not yet been provided

$16 USD / godzina
(0 Oceny)
0.0
EugeneZamytsky

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

$18 USD / godzina
(0 Oceny)
0.0
romanprof

Предложение еще не подано

$20 USD / godzina
(0 Oceny)
0.0