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.
| Author |
Topic |
|
hheijmans
Starting Member
1 Post |
 Posted - 2005-12-23 : 05:53:41
|
| I have SQL2000, SP3. Been trying to do a very simple BULK INSERT. My Format File looks like this - 8.0 31 SQLNCHAR 0 8 "|" 1 DOCNUM Latin1_General_CI_AS2 SQLNCHAR 0 32 "|" 2 Database_Name Latin1_General_CI_AS3 SQLNCHAR 0 4 "|" 3 Version Latin1_General_CI_ASI 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 "Latin1_General_CI_AS" - which I got from SQL Server Properties - Window. Same error. Any idea? Thanks. |
|
|
|
|
|
Bulk insert. Invalid collation