ADF: Is it possible to gracefully handle issues with a csv to Azure SQL import?

Solution 1:

In ADF, if you are using the Copy Activity, you will use the Fault Tolerance and Enable Logging features to achieve this. When transforming data with a data flow, you will use the "Error row handling" feature to achieve it.