June 12, 2008 at 10:28 am
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
June 12, 2008 at 9:06 pm
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
Change is inevitable... Change for the better is not.
June 13, 2008 at 12:00 am
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
June 13, 2008 at 1:18 pm
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
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply