Post reply

DTS - Variable length file

  • February 20, 2003 at 1:52 pm

    #105578

    Trying to use DTS to read a variable length file. File is 100 cols but if last char is in col 60 the crlf is after it and it does not load. Is there a way to make it think its fixed length?

    Thanks.

  • February 20, 2003 at 4:48 pm

    #449439

    Probably the best method would be to import the file into a staging table with only one field. Then run some SQL to spilt the record up into your destination table.

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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