Hi there!
We builded a DTS package on SQLserver 2000 that take some information of a SQLserver table (containing some special characters like "ñ") and put it on a AS400 table. The final result its an undesired effect. It transforms the "ñ" into a "#". We are using a copy column transformation.
Some people said me that it's a problem when the DTS try to write in a EBCDIC formatted table (like in as400), but honestly i don't know if that's the reason.
There is any option in the package, or any Activex script that allow me to handle this problem?
Tnxs for all the support!!!