We have a folder which every day receives a new CSV file from our remote plants. What we want to do is build a Powershell script that can be run on a schedule from within MS SQL and read these CSV files and insert them into a table. The file names are all the same name, but we need to read only the files we have not read in in the past.
Are there examples on this site which would help to write this powershell script and could you give examples of what I would use to get this working. I have about a day to get all this working.
I would start with Four Easy Ways to Import CSV Files to SQL Server with PowerShell
Powered by IDERA