Make sure there's no null in your CSV file. SQL Server threw the same error in our case because there was null present in some cells of the csv file.