October 7, 2003 at 9:04 pm
I using DTS to bring a fixed file into sql server. I keep getting a message about the delimeter not being in the first 8k of the record, which leads me to believe the record is larger than 8k but there are a lot of fillers in the record.Any suggestions? My row in the table is not larger than 8k, I'm stumped.
Thanks!
October 8, 2003 at 7:03 am
Is the data fixed column or separated by a delimiter. It looks like you specified delimited data in DTS but the data does not contain the delimiter specified.
p.s. DTS wizard looks at first part of data looking for separators so that it can determine the data structure.
Edited by - davidburrows on 10/08/2003 07:03:53 AM
Far away is close at hand in the images of elsewhere.
Anon.
October 8, 2003 at 1:08 pm
Hi David- Yes its fixed length and if I specify fixed with no delimiter it only shows me the 416 characters as the row...The row is actually 1600 characters long. I am wondering if I should have the file broken up into three smaller files, maybe its too big? Any suggestions? Thanks!
Thanks!
October 8, 2003 at 3:01 pm
do you have carridge return and linefeeds in the file?
October 9, 2003 at 2:04 am
I have no problem accessing 1600 byte fixed length records with DTS. Are you sure all records are 1600 bytes and as ghughes stated have got CR/LF. If your data is being truncated at 416, what is the 417th character, is a control char of some sort?
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply