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.