Need to insert CSV texts file into DB


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.


Skills: Microsoft SQL Server, T-SQL (Transact Structures Query Language), Scripting, Database Development, Database Administration

See more: 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

About the Employer:
( 0 reviews ) Riyadh, Saudi Arabia

Project ID: #21281996

43 freelancers are bidding on average $44 for this job


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

$100 USD in 2 days
(127 Reviews)

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.

$50 USD in 1 day
(8 Reviews)

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.

$80 USD in 7 days
(22 Reviews)

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

$30 USD in 1 day
(22 Reviews)

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 More

$50 USD in 2 days
(11 Reviews)

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 More

$100 USD in 1 day
(4 Reviews)

Please message me to start your work. Please review my profile. I have 9.8 years experience in MS SQL Server and 7 years experience in SSRS, SSIS (Import / Export). Plea More

$30 USD in 1 day
(15 Reviews)

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 More

$30 USD in 2 days
(4 Reviews)

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 More

$222 USD in 3 days
(3 Reviews)

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 More

$20 USD in 7 days
(5 Reviews)

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

$30 USD in 1 day
(1 Review)

------ 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 More

$30 USD in 7 days
(1 Review)

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 More

$30 USD in 1 day
(1 Review)

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

$30 USD in 7 days
(1 Review)

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 More

$30 USD in 1 day
(1 Review)
$55 USD in 1 day
(0 Reviews)

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 More

$50 USD in 2 days
(0 Reviews)

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 More

$30 USD in 2 days
(0 Reviews)

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 More

$25 USD in 2 days
(0 Reviews)

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

$20 USD in 7 days
(0 Reviews)