Post reply

Textfile problem

  • August 8, 2002 at 3:51 am

    #151721

    When importing a text file everyday I sometimes get the error 'Error at source for Row number XXXXX. Errors ecountered so far 1. Too many columns found in the current row; non-whitespace characters were found after the last defined column`s data'

    This is an MSProxy log and it only happens every now and again. I checked the error with msdn, and it says it`s cured in sql2k sp 2. I installed this, but nothing changed. Any ideas??

    Andy.

  • August 9, 2002 at 2:53 pm

    #434379

    Andy,

    Have you opened the offending file in Notepad to see what's going on?

    I've had a similar issue with Rhumba 2000's data file transfer. This program brings data down daily into a text file. It appearantly does not put a line feed after the last data downloaded. If a second days' data is appended to the file, the first caracter of the second download appears to the right of a CR like character on the last line of the first download and fouls my dts package.

    The only thing I can think of, is to put the file through a pre-process that would loop through the file and if the length of the line is greater than x characters dump the extra data into your own log file. If you're having the same trouble I am where lines are doubling up, this process could break the long line into two lines. It's also possible that your field definition may need to change.

    Good luck,

    John

Viewing 2 posts - 1 through 1 (of 1 total)

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