数据传输，从.csv到db。哪一个是最好的方法？

At the moment I'm working on a quite tricky transferring from a .csv file to DB. I have to develop a package/solution/xxxyyy that handles a flow of data from this .csv file to my SQL Server DB (the .csv is updated with new data everyday).At the moment I'm working on a quite tricky tra