Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot bulk load. Invalid column number in the format file Expand / Collapse
Author
Message
Posted Thursday, June 12, 2008 10:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 12, 2009 5:33 AM
Points: 68, Visits: 215
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

Post #516087
Posted Thursday, June 12, 2008 9:06 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 36,710, Visits: 31,158
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #516374
Posted Friday, June 13, 2008 12:00 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 12, 2009 5:33 AM
Points: 68, Visits: 215
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
Post #516429
Posted Friday, June 13, 2008 1:18 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 36,710, Visits: 31,158
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #517002
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse