Need to insert CSV texts file into DB

Închis Postat la acum 4 ani S-au achitat serviciile după ce au fost prestate
Închis S-au achitat serviciile după ce au fost prestate

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.

Server Microsoft SQL T-SQL (Transact Structures Query Language) Scripting Dezvoltare Baze de Date Administrare baze de date

ID Proiect: #21281996

Detalii despre proiect

40 propuneri Proiect la distanță Activ acum 4 ani

40 freelanceri plasează o ofertă medie de 46$ pentru proiect

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

$100 USD în 2 zile
(172 recenzii)
7.6
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 Mai multe

$50 USD în 2 zile
(28 recenzii)
4.9
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

$30 USD în 1 zi
(39 recenzii)
5.1
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.

$50 USD în 1 zi
(8 recenzii)
5.0
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 Mai multe

$30 USD în 7 zile
(18 recenzii)
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.

$80 USD în 7 zile
(24 recenzii)
4.6
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 Mai multe

$100 USD în 1 zi
(4 recenzii)
4.0
khaldalfalah

Hi, I can build a tool to read from these csv files and insert data into ms sql server and allow to run automatic once time every day. I have experience in MS SQL server,asp.net, crystal reports and VB.net more than 12 Mai multe

$29 USD în 3 zile
(7 recenzii)
3.9
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 Mai multe

$30 USD în 1 zi
(17 recenzii)
4.0
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

$30 USD în 1 zi
(7 recenzii)
3.6
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 Mai multe

$20 USD în 7 zile
(7 recenzii)
3.1
soumyaphegde

I have created applications which reads data from CSV files in a certain folder, does some validation and inserts data into MS SQL server. I have understood your requirement very well and would be able to help you quic Mai multe

$30 USD în 5 zile
(2 recenzii)
2.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 Mai multe

$30 USD în 2 zile
(6 recenzii)
3.0
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 Mai multe

$222 USD în 3 zile
(4 recenzii)
3.1
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 Mai multe

$30 USD în 1 zi
(1 părere)
1.8
j3pro

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

$30 USD în 7 zile
(1 părere)
0.7
dimatechit

hi , i understand your requirements , i can do this , do not worry please message me for more details . best regards

$20 USD în 2 zile
(0 recenzii)
0.0
senthilm2005

I noted your requirements and will provide my best work with low margin. thank u. I have a 15 years experience in this field.

$18 USD în 2 zile
(0 recenzii)
0.0
rp07364

Hi, Thank you for sharing this interesting project. I am very much interested in this project. I am well experienced Web Developer from the industry and I can create the tables and can CSV files into the database. I Mai multe

$20 USD în 7 zile
(0 recenzii)
0.0
keshavkrishna

I am basically an ETL developer and have experience on both Oracle and SQL Server database. Apart from completing the job, I will also provide step by step documentation of process flow.

$30 USD în 7 zile
(0 recenzii)
0.0