Max length of a csv line

Posted on 2014-04-01
Medium Priority
Last Modified: 2016-02-10

   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?
Question by:LuckyLucks
  • 2
LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 39970791
Are you sure there are no line feeds in your data?

Author Comment

ID: 39971369
Its a select * from the view...so there shouldn't be a linefeed. How can I verify this?
LVL 39

Expert Comment

ID: 39971380
Something like this:

SELECT * FROM some_table
WHERE CONTAINS(some_field, char(13)) OR CONTAINS(some_field, char(10))
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39981957
How many rows in the VIEW and how many rows in the CSV?

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question