on 10-09-2014 4:29 PM
We're trying to bulk copy into a table with an unsigned bigint column and sometimes it works and sometimes it doesn't
I've created a variety of tables and BCP-ed into them.
Here are the tables and whether they work,
Table : lock scheme AllPages. BCP WORKS
UId int
BId smallint
Line int
PID int
PDate datetime
PV varchar(255)
ES unsigned bigint
Table : lock scheme DataRows. BCP FAILS
UId int
BId smallint
Line int
PID int
PDate datetime
PV varchar(255)
ES unsigned bigint
(Change type to signed bigint)
Table : lock scheme DataRows. BCP WORKS
UId int
BId smallint
Line int
PID int
PDate datetime
PV varchar(255)
ES bigint
(Make unsigned bigint not the last column)
Table : lock scheme DataRows. BCP WORKS
UId int
BId smallint
Line int
PID int
PDate datetime
ES unsigned bigint
PV varchar(255)
It seems to be that unsigned bigint columns work so long as its not the last column.
Is this a known limitation/bug ?
Is there a fix ?
Hi Mike,
You mention C# and bcp. I think you are using bcp utility?
Can you be more specific - bcp version, ase version, and the bcp command line used, exactly? Also, post the error you are receiving.
Cheers,
-Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> You mention C# and bcp. I think you are using bcp utility?
No I'm using C#.
I'm using SDK SP122 (I forgot to include this).
See SyBooks Online AseBulkCopy Class.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.