Developer's Cogitation

Now run following script to load all the data from CSV to database table. If there is any error in any row it will be not inserted but other rows will be inserted.BULKINSERT CSVTestFROM c:/cs

http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/20e3dbc2-913a-4433-be7d-7f6ef81625cf/