Mar 05, 2019 03:00 AM|Ackerly Xu|LINK
StreamReader .ReadLine should read one line at a time, I am not sure why read one line at a time will cause performance problem.
Maybe your csv has too many rows and your store the whole rows into a datatable.
If you want to format your csv , you could try to covert it to excel and use excel to format your csv.
About importing , ssma could also import data from csv.