October 12, 2001 at 1:48 am
I want to bcp data from a file into SQL table using a format file.The data file has tab as the feild delimiter.When delimiter is anything other than tab, the bcp works.
The error message says :
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
I cannot use delimiters here as the data source is out of my bounds.
The Command i am using is as given:
bcp sbs.tblTEArch in c:\osp\sbs\testfiles\test4.txt -t \t -S nentsdlg -U sbs -
s -f c:\osp\sbs\fmt4.fmt
Josh
Edited by - josh_ahoy on 10/12/2001 05:45:31 AM
Edited by - josh_ahoy on 10/12/2001 05:48:19 AM
Josh
October 12, 2001 at 4:45 am
String truncation just means you're trying to push a string into a column that is not wide enough. You'll either have to identity which column it is and fix that one, or pad all of them to get it loaded, then figure it out.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply