Reading a csv one line at a time and importing to sql
I have a csv that has over 6 million rows and 300+ columns. I need a way to read the csv one line at a time and then I can execute the stored procedur to push it by parameters to the sql server. I can read the file but I am not able to use an array due to an out of memory exception. Any advice would be greatly appreciated.