Cannot bulk load. Invalid column number in the format file

• sharma-691993

  SSCrazy

  Points: 2194

  More actions

  June 12, 2008 at 10:28 am

  #187092

  Hi I am loading data from .txt file

  8.0

  5

  1 SQLCHAR 0 8 "|" 1 NUM COLLATE SQL_Latin1_General_CP1_CI_AS

  2 SQLCHAR 0 8 "|" 2 ID COLLATE SQL_Latin1_General_CP1_CI_AS

  14 SQLCHAR 0 8 "|" 3 name COLLATE SQL_Latin1_General_CP1_CI_AS

  37 SQLDATETIME 0 8 "|" 4 Dob ""

  44 SQLDATETIME 0 8 "|" 5 datejoin ""

  It shows below error

  Cannot bulk load. Invalid column number in the format file

• Jeff Moden

  SSC Guru

  Points: 1004621

  More actions

  June 12, 2008 at 9:06 pm

  #828212

  8.0

  5

  1 SQLCHAR 0 8 "|" 1 NUM COLLATE SQL_Latin1_General_CP1_CI_AS

  2 SQLCHAR 0 8 "|" 2 ID COLLATE SQL_Latin1_General_CP1_CI_AS

  3 SQLCHAR 0 8 "|" 3 name COLLATE SQL_Latin1_General_CP1_CI_AS

  4 SQLDATETIME 0 8 "|" 4 Dob ""

  5 SQLDATETIME 0 8 "|" 5 datejoin ""

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• sharma-691993

  SSCrazy

  Points: 2194

  More actions

  June 13, 2008 at 12:00 am

  #828259

  Thanks for ur reply..

  You had changed 1,2,14,37,44 as 1,2,3,4,5

  But it is host file field order only.

  I have to specify sequence order? Because

  i am selecting 1,2,14,37,44 filed from table (file) and then load into destination table as 1,2,3,4 and 5 order.

  Now also it shows same eror

• Jeff Moden

  SSC Guru

  Points: 1004621

  More actions

  June 13, 2008 at 1:18 pm

  #828759

  sharma (6/13/2008)

  ---

  Thanks for ur reply..

  You had changed 1,2,14,37,44 as 1,2,3,4,5

  But it is host file field order only.

  I have to specify sequence order? Because

  i am selecting 1,2,14,37,44 filed from table (file) and then load into destination table as 1,2,3,4 and 5 order.

  Now also it shows same eror

  Ugh... that's what I thought you did... post the record layout for the file and lemme show you what you need to do...

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)