cancel
Showing results for 
Search instead for 
Did you mean: 

C# BulkCopy only sometimes supports unsigned bigint fields

Former Member
0 Kudos

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 ?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

> 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.