Loading of csv file , text file into database

I came across a situation i have to load .csv file into database long back. Although there are many methods exists, all they have their own merits and demerits . i recommend people to go for bulk insert because of its faster response.
here i am providing a discussion which of course done when i am working on loading .csv file into sql.
http://www.sqlservercentral.com/Forums/Topic380386-61-5.aspx