Thanks Craig for your reply. I am able to resolve the issue. I am posting the link for whoever wants help on this

http://www.ssistalk.com/2007/03/14/ssis-working-with-cobol-zoned-signed-decimals/

Thanks Craig! It's a fixed width easily identifiable string. I am working on creating variables able to derive the values but not able to get the negative values, code is...