I have SQL2000, SP3. Been trying to do a very simple BULK INSERT. My Format File looks like this -

8.0
16
1 SQLNCHAR 0 8 "|" 1 DOCNUM ""
2 SQLNCHAR 0 32 "|" 2 Database_Name ""
3 SQLNCHAR 0 4 "|" 3 Version ""

I kept getting Error 4839 Invalid Collation Name at the last column. I have tried using "RAW" at the end of the line, or empty "", or the actual collation name "SQL_Latin1_General_CP1_CI_AS" - which I got from SP_Help TableName. Same error.

Any idea? Thanks.