Bulk insert problem with sql server 2005

• Bill J-322806

  Newbie

  Points: 3

  More actions

  January 30, 2007 at 10:24 am

  #369089

  I am running into a seemingly random bulk insert problem using sql server 2005.  I load flat files nightly using a format file and am sporadically receiving the following error:

  "Cannot bulk load.  Invalid destination table column number for source column 1."

  When I run the exact same t-sql code a second time it works fine.  I have checked the format files and they have the correct version number (9.0) and the correct layout.  These are bulk insert statements which have worked fine for the last couple of years in sql server 2000.

  Has anyone encountered this problem?

  thanks, b -

• Jesus Cardenas Mercado

  SSC Veteran

  Points: 206

  More actions

  January 31, 2007 at 9:20 am

  #686889

  It sounds like a permissions issue, have you check it out.

• Vinod Pal

  Old Hand

  Points: 345

  More actions

  February 5, 2007 at 9:28 am

  #687809

  In SQL 2005 u need ALTER TABLE permissions to be able to perform the BCP.  Check in BOL.