I'm managing to run across DTS from 2005 to Ora 10 g.

But, i'm getting a type error when the types match okay when moving data from Ora->MS

"Error converting data type varchar to numeric"

Any ideas? I believe it's connected to the first SQL In the openquery syntax