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.
43 freelance font une offre moyenne de $44 pour ce travail
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
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.
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
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
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
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
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
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
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
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
------ 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
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
Hello, My name is Juan. I have experience with SQL. I would like to work in your project. Best Regards,
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
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
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
i can done your your project .i have 4 years of experience of back end front end develpoer..............