how are the tables exposed. Are they on a linked server.

Can you ask the vendor for table definitions. You will probably find that you are not even looking at the tables but some views generated specifically for exposing data to you.

you could try treating each column as varchar until you know better and use a dataConversion task to interrogate rows and change them to the desired values but this would not provide you with a generic approach.

Good luck if the DB2 vendor won't help you

Obiron