Fermé

Need to insert CSV texts file into DB

Hi

I have four folders contains text files as CSV format. I need to create SQL script to insert all the files into four tables with it's own column for each comma separated contented in each file.

Plus I need to add the folder name from where this texts came from in each table.

Last but not least, need this script to be run once a day to take from the same source and must avoid duplication of files.

Please need help, I'm trying to find a solution for this problem while ago.

Thanks.

Compétences : Serveur SQL Microsoft, T-SQL (Transact Structures Query Language), Scripting, Développement de bases de données, Administration de Bases de données

en voir plus : how to import csv file in mysql using command line ubuntu, import csv into mysql workbench, mysql create table from csv, import large csv file into mysql workbench, mysql import csv command line, import csv file into mysql using php, import csv to mysql phpmyadmin, how to load the csv file into mysql

Concernant l'employeur :
( 0 commentaires ) Riyadh, Saudi Arabia

Nº du projet : #21281996

43 freelance font une offre moyenne de $44 pour ce travail

sumon355

Hello, I can provide you a C# based program to achieve the thing you are looking for. It is not possible do it only by sql script. Looking forward to have a positive response from you. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(127 Commentaires)
7.3
harishpanoor

I am a SQL server database and ETL developer. I can do this project in 1 hr using SSIS tool and give the package. Please contact me if you need to have more discussion on this. Thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
4.9
AliSafder

Hi, My name is Ali and I can work on it with immediate availability. Let me know when we can discuss so I can start.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(22 Commentaires)
4.5
Ahmed818

Hello, السلام عليكم i can write small script to load csv data from your input folder then save all to your sql server database i will deliver source code payment after job completion Thank you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(22 Commentaires)
4.7
jayantavkumar

The best way to use SSIS ETL tool to extract such kind data and insert into database tables. Else I can provide you sql query also to pull the data directly from T-SQL window. Let me know if you want to discuss furth Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(11 Commentaires)
3.8
octacer

Hi Sir, Its Hisham. I am Software Engg. with more than 3 years of market experience. I am a Full Stack Developer. I have developed many web and cloud based solutions for my clients. I have been developing sol Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
4.0
vw7590795vw

Please message me to start your work. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.8 years experience in MS SQL Server and 7 years experience in SSRS, SSIS (Import / Export). Plea Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)
3.9
l0ginp

Hi, I am keen to work for those who need an expert in SQL Language and Database System. More than 7 years experience in many project on SQL, non-SQL, and Database Management such as MS SQL, Oracle, mySQL, Postgresql, M Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
2.9
OWDGroup

Hi, I'm a database architect and programmer having more than 15 years of experience with different types of domains like telecom, banking, payroll, crm, ecommerce etc with high data volumes and I'm experienced with or Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
3.0
mostafawalker

i'm highly skilled C# programmer and SQL developer , i can write sql script to insert that csv files into the database , or i can write c# application simple to insert it into the database , please contact me to discus Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(5 Commentaires)
2.3
goodwork20k

I am good in powershell and SQL along with automation and development, please let me know if you are good to award this project to to me

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.5
tutulsoft

------ READY SOLUTION WILL DELIVER YOU LESS THAN A DAY ------------- Step to Deliver : 1) need to discuss , 2) verify your table and sample CSV file 3) customization start into my ready tool 4) Delivery ---- total w Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
1.2
rk123c

Hey Hi, I'm a full stack application developer having 3+ years experience. I've got the requirement. You have files and that to be stored in database on daily basis. I can create a schedular script. I'm very good in Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.0
j3pro

Hello, My name is Juan. I have experience with SQL. I would like to work in your project. Best Regards,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
0.7
AbhishekSingh08

All of our programming skills: *Front-end: - HTML, HTML5, JSON. - JAVASCRIPT (Ajax, AngularJS / 2 / 4 / 5 / 6 / 7, ReactJS - Redux, Jquery). - CSS, CSS3, Twitter Bootstrap, Less, Sass, Scss, Responsive, Material. - M Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.8
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
AlsayedKhalid

Hello Sir/ Madam, I can do your project, you will get a database application consists of a form used to load data from excel files. I have 15 years of experience in building database applications Contact me ... reg Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
sumitsalunkhe3

Hello, I have 5 years of experience as an SQL Server Developer. As per your requirements and I have completed the 70% of the task already. I can deliver this task within 1 to 2 days. Please let me know If you are inter Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
deleepkumar

hi, I have 13 years of experience in software development and I have worked on several datawarehouse projects as ETL developer and data modeller. I have gone through your requirement description thoroughly and I unde Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
khalilrodini

i can done your your project .i have 4 years of experience of back end front end develpoer..............

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0