I would like your help again.
I have some files in csv format to be imported into SQL Server.
The files have the following format:
Where 01 would be the 06 month and 2016 year.
I have a file for each day of this, I need to import these files to the SQL SERVER automatically where each file would be a different table.
Could help me do this in powershell because the way I'm doing, it takes a long time.
Each CSV file has a character | the end of the line, I have to take this character of each file to import does not cause error.
attached a file of the model.