SSIS: Fixed Width Columns Aren't Displaying Correctly

2
votes

I am trying to create a fixed width flat file import spec in SSIS. When I set up all of the columns with the correct widths and preview them, the first row is correct but all of the other rows are off.

example:

Row 1: Text

Row 2: [space]Text

Row 3: [space][space]Text

What am I doing wrong?

Thanks in advance!

1
ssis
What's your actual delimiter in the flat file import source? – Tom Pickles
There is no delimiter. For example, if the first 12 characters were ABCDEFGHIJKL, then it would be col 1 - ABCDE, col 2 - F, col 3 - GHIJ, col 4 - KL, etc. – divided

1 Answers

2
votes

I have experienced something similar to this whenever I first sat up a fixed width column and did not properly adjust for the data between the end of text (or delimiter) to the next line. The data in this area is usually spacing and the carriage return/line feed. To adjust properly, I created one extra column that handled the data from the end of text (or delimiter) to the next line. This fixed my spacing issue.