如何在SSIS或其他工具中处理带有许多抑制列的不规则的右侧文本文件？

The ragged right flat file option is great for a single trailing field terminated with a CRLF, but when any number of trailing fields which are blank are suppressed and the line terminated early with CRLF, I have found no alternative in SSIS but to read a few columns in with a single "REMAINDER" column and then used a Derived Column transform with SUBSTRING operations to extract the "optional" columns one by one.The ragged right flat file option is great for