Post reply

Export flat file with no {CR}{LF} after last row

  • February 4, 2009 at 9:12 am

    #155226

    Based on my initial searches on this, it looks like this topic has been around the block a time or two! Alas, I have not found an actual solution yet that deals with it in SSIS.

    I want to export a flat file that has no {CR}{LF} at the end of the last row. The subsequent import thinks it's a new, blank row and pukes on it.

    Any help is greatly appreciated.

  • February 9, 2009 at 8:48 am

    #940534

    Seemed like no matter how I exported the text file via SSIS components, it always had an "extra" blank line at the end of the file after the last cr lf. My workaround was to create a blank record in my file format using notepad2 and made sure there was no cr lf at the end of the record. Now I append that text file to the end of my text file created via SSIS and apparently the recipient can now process the file without error.

    Not ideal, but it works....

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

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