Hi JJ,

Thanks for the update.

As for the padding character, based on my scope, it is the SSIS inserting
spaces in the last column if the row comes up short.

The fixed width in SSIS is different with other like DTS or Excel. In DTS,
it will use the row delimiter to seperate the row. But in SSIS, it does not.

I suggest you use the ragged right since it is more like the 'fixed width'
behavior in Excel and DTS which you are familiar with.

To provide your feedback directly to the product groups:
http://lab.msdn.microsoft.com/produc...k/default.aspx

Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

To get the workaround and Step by Step description for developing SSIS package in order to overcome the issue with SSIS while importing text files with Flat File Connection Manager and Flat File Source where the "Row Delimiter" property does not work properly for rows having NULL or empty values, follow the below link:
http://www.sqllion.com/2010/04/ssis-...e-importing-1/
Thanks,
SQL Lion


From http://www.developmentnow.com/g/103_...Recognized.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

To get the workaround and Step by Step description for developing SSIS
package in order to overcome the issue with SSIS while importing text files
with Flat File Connection Manager and Flat File Source where the "Row
Delimiter" property does not work properly for rows having NULL or empty
values, follow the below link:
<a href=”http://www.sqllion.com/2010/04/ssis-...mporting-1/” >
http://www.sqllion.com/2010/04/ssis-...e-importing-1/ </a>
Thanks,
SQL Lion


"unknown" wrote:

>