Iam using flat file destination using a flat file connection manager to write data into a file with .FILE extension. The source data is of a single column of width 40 characters. When setting up connection manager, I used Fixed Width mode and also used CR-LF
as Header row terminator. The source is from a Stored procedure witha table select which returns data with 40 characters width.
But when I execute the package and open the file using notepad I can see that all the rows are coming one after the other instead of one below the other. I have been trying to solve the issue, but am not able to. Can some one help where I would have gone
View Complete Post