LuckyLucks
asked on
Max length of a csv line
Hi EEEE:
I am exporting data from a MS SQL 2008 into a csv using SSIS that selects all rows of a view. I noticed that the count(*) of the view didnt match the csv. Its likely because there is a max length for a line and thats being exceeded by certain rows which is forcing a newline and a separate additional row.
Could you tell me what the max length of a row is and how to fix this issue?
I am exporting data from a MS SQL 2008 into a csv using SSIS that selects all rows of a view. I noticed that the count(*) of the view didnt match the csv. Its likely because there is a max length for a line and thats being exceeded by certain rows which is forcing a newline and a separate additional row.
Could you tell me what the max length of a row is and how to fix this issue?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Something like this:
SELECT * FROM some_table
WHERE CONTAINS(some_field, char(13)) OR CONTAINS(some_field, char(10))
SELECT * FROM some_table
WHERE CONTAINS(some_field, char(13)) OR CONTAINS(some_field, char(10))
How many rows in the VIEW and how many rows in the CSV?
ASKER