Post reply

Text File is truncated

  • June 3, 2004 at 9:29 am

    #161596

    I have a DTS package the take a column that is defined as VARCHAR(6000) using '|' as a delimiter and exports it to a text file. But in the text file some of the records are being truncated. Is there a limitation on the width of a records going into a text file? Please advise...


    Arthur Lorenzini

  • June 4, 2004 at 9:33 am

    #509043

    Arthur

    How many characters per line are there?  If you are opening the text file, what program are you using?  What is the maximum number of characters? (I mean is there a maximum length for each line or are the lines that appear to be truncated of different length?)

    Charlie

     

  • June 7, 2004 at 3:44 pm

    #509341

    Probably yoy have this problem

    http://www.sqldts.com/?297

    JFB

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

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