Click here to Skip to main content
12,749,754 members (32,026 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQL-server-2005 C# SQL-Server , +

I have one Stored procedure that returns one column with number of rows. All this rows should be written in the Raw file(not text file). When i use Raw File Destination in SSIS package for storing data in file, it is not writing each line on new line. it append some junk character(this may be new line character character ASCII value).

How can i write each table row in new line inside Raw file.

Hope for someone's help.

Posted 17-Dec-12 1:54am
ryanb31 17-Dec-12 8:21am
Can you be more clear? Are you saying you don't want SSIS to write a new line character?
@AmitGajjar 17-Dec-12 8:25am
I have added SSIS as tag so thats fine. anywhere code will be fine. just want to separate each line in Raw file with new line.
ryanb31 17-Dec-12 8:28am
I'm confused. You say you do want a new line? But you also said SSIS was writing the new line ascii character. So, what is the problem?
@AmitGajjar 17-Dec-12 8:31am
When in open Raw file in notepad it is showing me junk character. but i want each database row in new line when i open it in notepad.
ryanb31 17-Dec-12 8:39am
What are the properties on your destination file? For example, do you have a RowDelimiter or a HeaderRowDelimimter set?
@AmitGajjar 17-Dec-12 8:47am
Let me check and get back to you.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1


Rows are created based on the delimiter u specify in the flat file connection.
In your Flat File connection manager set the row delimiter property to {CR}{LF}

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170215.1 | Last Updated 8 Apr 2014
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100