BCP export/Import >> More Columns in Table than in Data File

• IMary

  Old Hand

  Points: 361

  More actions

  January 5, 2020 at 9:26 am

  #3712431

  Hi,

  I'm using BCP to export and import.

  Steps followed:

  1. Took BCP export for Table A (Which has 14 columns )

  2. Dropped this Table A and created again with one extra column. Now this tables will have 15 columns.

  3. Created formatted file for the recreated table.

  4. Ran BCP import with export data file took in step1 and format file took in step3.

  Getting below error:

  Starting copy...

  SQLState = S1000, NativeError = 0

  Error = [Microsoft][ODBC Driver 13 for SQL Server]Attempt to bulk-copy an oversized column to the SQL Server

  I have tried modifying the format file as suggested in below link but still getting the same error. Please advise.

  https://www.red-gate.com/simple-talk/sql/database-administration/working-with-the-bcp-command-line-utility/

• IMary

  Old Hand

  Points: 361

  More actions

  January 5, 2020 at 10:07 am

  #3712434

  and new column is not null column.

• Thom A

  SSC Guru

  Points: 99130

  More actions

  January 5, 2020 at 11:33 am

  #3712439

  Is this a cross post of your question here? https://www.sqlservercentral.com/forums/topic/bcp-33

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk