Post reply

Row Delimiter Problem

  • August 25, 2005 at 6:38 am

    #66888

    Hello,

    For months I've been importing a fixed width text file into a sql table through dts without a problem. Today, for some reason, the dts cannot see the row delimiters in the file. It ends up wrapping the second row into the first, the third into the second, as so on...

    I can import it in Access 2000 with no problem. Access can see the delimiters.

    Has anyone run accross this before????

    Thanks,

    DL

  • August 26, 2005 at 1:55 am

    #585303

    I presume you have a record with a new line (CRLF) within a field. Have you got text qualifiers switched on ? What are the delimiters ? Can you post the first few lines of the file, it might help ?

    Dan
    www.firstcs.co.uk

  • August 26, 2005 at 7:04 am

    #585357

    Noggin,

    Thanks for responding.

    The file is a fixed width file. There is a CRLF at the end of each row. For some reason DTS doesn't recognize this while Access does. Anyway, I changed the properties of the source text file to delimited with commas. This somehow forces DTS to recognize the row delimiters. I know that this doesn't make any sense but it worked.

    DL 

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

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