i got similar error w/ some groupmates in here for the DTS transformation.
i had checked my data, that field in fact store the currency and all with valid data exists. but when i run the DTS, still got the following error:

(Microsoft Data Transformation Services (DTS) Data Pump (8004202c): TransformCopy 'AxScriptXform' conversion error: General conversion failure on column pair 33 (source column 'CurCode' (DBTYPE_STR), destination column 'CurCode' (DBTYPE_BYTES)).)

so anyway to check what is happening?

i had checked:
1. data in source table and destination table
2. the column datatype, i haven't set the datatype in code so they will use default.

what else i can check??

Thanks for any help!!