I have a strange problem with SSIS. I am exporting some data from a database to a flat file. It's all okay. Comes out - instead of displaying the data:
ID First Name Last Name Age
It comes like this:
Now, it is not repeating the same data (ever), so the data can actually look like this:
ID FirstName LastName Age ID1 FirstName1 LastName1
>1 John Doe 23 2 Jane Do 22
Why is it repeating?
actually fixed width records (code only Your choice in the text in the page), one after the other with nothing in between - you have to add a record / line delimiter - in this case CRLF.
If you have a flat file destination component And click the new button to make a destination data adapter correct. Switch to - "Wizard" you that the difference between the fixed width and fixed width gives four options line delimiters that it just puts a little Siarelf column at the end.