Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    2

    Question Unanswered: DTS doesn't recognize CRLF in Text File

    I'm using DTS to import a text file (fixed field). In my sample data, I have 21 rows of data.

    DTS only brings in 15 or so, because it fails to recognize the CRLF on some of the rows, and just treats it and the subsequent row as part of the previous row.

    The text file is being produced via FTP from an IBM Iseries. It imports just fine into Notepad and Excel.

    Anyone have any ideas why DTS would have trouble with this ?

    Thanks

    Greg

  2. #2
    Join Date
    Sep 2005
    Posts
    2
    nevermind....apparently DTS requires flat text files to be padded with blanks in order to make all the records exactly the same length. I don't know why DTS is so picky about this when every other Micro$oft application isn't.

    I reckon I'll just make it comma delimited and be done with it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •