Destination Flat File creates empty row at end of csv file RRS feed

  • Question

  • I am exporting SQL table data to a csv file. An empty row is created at the end of the csv file, which creates a problem for another application that imports the csv file. Why is this empty row being created, and how can I stop this?
    Friday, February 4, 2011 8:17 PM


  • It happens because at the end of each line CR & LF is used as new line character. If you do not want that you could use a script task to delete the last line after the data flow task.
    Sudeep's Domain
    • Proposed as answer by SaeedB Sunday, February 6, 2011 3:55 AM
    • Marked as answer by Jerry Nee Tuesday, February 15, 2011 4:50 AM
    Friday, February 4, 2011 8:37 PM