bcp import error numeric value out of range

Question

bcp import error numeric value out of range

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

sturner SSC-Insane Points: 22471 More actions · Answer 1

You don't want to use RAW in this case because it expects the data types to be the same. Use something other than RAW, or use a query out that casts (or converts) the ints to bigints and writes those to the file.

The probability of survival is inversely proportional to the angle of arrival.

videl666 SSC-Addicted Points: 408 More actions · Answer 2

The problem is that, that i can't modify bcp out command. I need to find solution to import int data from dat file created with -CRAW option to bigint table. Is this possible? Using format file will be helpful? If yes How use it?

sturner SSC-Insane Points: 22471 More actions · Answer 3

Okay, then your only other option is to bcp in to a stage table that has ints, then do a final insert into the destination table having the bigints.

The probability of survival is inversely proportional to the angle of arrival.

videl666 SSC-Addicted Points: 408 More actions · Answer 4

Ok, thanks....I was hope that i can do this in other way - not inserting in int table and copying data from it to bigint.....

sturner SSC-Insane Points: 22471 More actions · Answer 5

videl666 (2/6/2014)
Ok, thanks....I was hope that i can do this in other way - not inserting in int table and copying data from it to bigint.....

Well, I supposed you could alter the columns of the destination table to be ints before the BCP IN, then alter the columns afterwards to bigints.

The probability of survival is inversely proportional to the angle of arrival.

videl666 SSC-Addicted Points: 408 More actions · Answer 6

Hmm... I can't do that because in destination table i have other bigint data......