Flat File loading issue

While loading the flat file into sql server2005 using SSIS , i am getting error like:

[Source - 20070801PensionPayments_dat [1]] Error: The "output column "Status" (246)" failed because truncation occurred, and the truncation
row disposition on "output column "Status" (246)" specifies failure on truncation. A truncation error occurred on the specified object of
the specified component.

In the EM import wizard, i can see last column [][](blank space similar box type). because of that i unable to load data into table. The delimiter is fixed width.

Please help me - Thanks in Advance.

You need to make the column big enough to capture the data in the source file, before trying to get rid of spaces.

Adjust your flat file source to give that column enough length to capture the data.

Then you can use a derived column to remove spaces from that field.|||

The Source file table name is :

Columns type Remarks MemberFirstName nchar(20) Firstname MemberLastname nchar(20) Lastname MemberPrefix nchar(4) <blank> MemberSuffix nchar(4) Suffix Status nchar(1) <blank>

Sample data like , only first name has value remaining columns blanks using of nchar data type.

While extrating the data , i am using Fixed width --> delimiter,even though last column giving problem

Ex:

MARIANN|||Your flat file mapping is not correct. There is more data coming in via the file than the source is set to handle. Fix that first.