John,

I checked the length of the field and column. They are in sync.Also when I re ran my package, it executed without any problem. I am looking for the reason why it happened. Will post it if I get any clue.

Thanks

Parul