Ok, I could figure it out..

I went to Source OLEDB, Advanced Editor and Input and Output parameters.

There I have compared the length of the column in External Columns and Output columns.

External Column has length 100 which is coming from Access is set to 100.

Output Column was set to 60, strange I never changed that , is it default setting in SSIS?

I have changed this length to 100, it worked like charm.

Thanks Keon and rhty for your thoughts..