Thanks Divyanth. I am trying extended properties. Will let you know once it works.

Phil,

I am migrating sql server varchar(30) datatype field.

reason behind this is we don't want to throw error at that point and migrate every file from user into dummy table....

Thank you divyanth.

For now quick fix changing a number field to text field in excel file worked but I need to have some permanent fix as user may not change...