>I am trying reading a CSV using APPEND FROM, but the CSV contains a strange date format which cannot get recognized, any SET DATE I am trying does not work. In CSV it looks like this:
>
>2000-12-06
>
>Anybody has an idea to make the append work without the need to parse it line by line?

Looks like normal yyyy-mm-dd format of the date to me. You can try to get data into SQL Server.