Bulk insert into SQL Server 2005 issue -

i've tried bulk insert can't right. have table schema starts id , few more columns need skip column. whats proper way assign columns each 1 csv?

thanks

edit:

my code:

bulk insert datadb 'c:\datainsert.csv' ( firstrow=2, fieldterminator = ',', rowterminator = '\n' ) go 

the errors talking first column being different datatype since have id column

i have tested same , working without issues.

please post metadata of table , csv file, chance find issue.