Bulk Insert - codepage

• discotech

  SSC Veteran

  Points: 214

  More actions

  December 4, 2003 at 9:55 pm

  #83668

  Hey there.

  I'm using bulk insert with a format file on SQL Server 2000. All fields in my format file are SQLCHAR.

  When I specify CODEPAGE = 1252 (or 'ACP', 'OEM') in the bulk insert statement I get the following error:

  "Cannot perform bulk insert. Invalid collation name for source column 1 in format file..."

  I get the same error if I omit the codepage clause.

  If I modify the format file and specify a collation for each column of SQL_Latin1_General_CP1_CI_AS then the insert works!!

  My collation serverproperty is SQL_Latin1_General_CP1_CI_AS.

  Help...!?

• Pascale Breyne

  SSC Rookie

  Points: 45

  More actions

  September 13, 2005 at 7:44 am

  #589354

  Add a Carriage Return at the end of the format file.