Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Bulk Insert Collation Error

Author  Topic  adamak Starting Member 7 Posts Posted - 2002-02-15 : 10:33:13 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.