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