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?
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.
Proposed as answer bySaeedBSunday, February 6, 2011 3:55 AM
Marked as answer byJerry NeeTuesday, February 15, 2011 4:50 AM
