Raw file with new line character

Question

4.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Hi,

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.

Thanks
-Amit

Posted 17-Dec-12 0:54am

AmitGajjar

Add a Solution

Comments

ZurdoDev 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.

ZurdoDev 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.

ZurdoDev 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

Add a Solution

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

Guruprasad.K.Basavaraju · Answer 1 · 2014-04-08T09:09:00

Solution 1

Amit,

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}

Posted 8-Apr-14 9:09am

Guruprasad.K.Basavaraju

Updated 8-Apr-14 9:11am

v2

Raw file with new line character

1 solution

Solution 1

Add your solution here

Preview 0

Raw file with new line character

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us