Need to insert CSV texts file into DB
$10-30 USD
Pagado a la entrega
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.
Nº del proyecto: #21281996
Sobre el proyecto
40 freelancers están ofertando un promedio de $46 por este trabajo
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
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 Más
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
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.
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.
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 Más
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 Más
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
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 Más
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 Más
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 Más
Hello, My name is Juan. I have experience with SQL. I would like to work in your project. Best Regards,
hi , i understand your requirements , i can do this , do not worry please message me for more details . best regards
I noted your requirements and will provide my best work with low margin. thank u. I have a 15 years experience in this field.
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.