bulk insert problem

• Sergio Campos

  SSC-Addicted

  Points: 459

  More actions

  August 31, 2006 at 1:37 am

  #153165

  hi i am trying to import a file with bulk insert.

  i get this error:

  Import failed: Bulk insert data conversion error(truncation) in row 1, colum 2

  Bulk insert: DataFiletype was incorrectly especified as char. Datafiletype will be assumed to be widchar because the data file has a Unicode Signature.

  OLE DB error trace[OLE/DB provider'STREAM' IRowset::GetNextRows returned 0x80004005 : The provider did not give any information about the error]

  It's sure that column 2 is a char , it containts two characters AB or BI ...

  I use this :

  BULK INSERT aux_prob1

  FROM 'd:\aux_1.txt'

  WITH ( ROWTERMINATOR = '|\n',

  CODEPAGE='ACP')

• Gosta Munktell

  SSCertifiable

  Points: 6004

  More actions

  September 1, 2006 at 5:12 am

  #657980

  What do you have in column1 ?

  The default datafiletype for bulkinsert is char.

  Maybe

  WITH ( ROWTERMINATOR = '|\n',DATAFILETYPE='widechar',

  CODEPAGE='ACP')

  will solve the problem.

   

  /gosta