CODEWITHSUNDEEP
ssis
divided
divided

Reputation: 1319

SSIS: Fixed Width Columns Aren't Displaying Correctly

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!

Upvotes: 2

Views: 2878

Answers (1)

David Benham
David Benham

Reputation: 1174

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.

Upvotes: 3

Related Questions