开发者

SSIS: Fixed Width Columns Aren't Displaying Correctly

开发者 https://www.devze.com 2023-03-05 16:08 出处:网络
I am trying to create a f开发者_开发知识库ixed 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 ot

I am trying to create a f开发者_开发知识库ixed 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!


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号