Viewing 2 posts - 1 through 2 (of 2 total)
Same as before. Just to confirm what I'm doing:
in the data flow task, delete the existing OLE DB source
create new source pointing at the connection manager for Oracle
set data...
July 31, 2008 at 10:18 am
#851393
I've just tried that with the same outcome as before. My source query contains CAST(AMOUNT_DUE_ORIGINAL AS DECIMAL(10,2)) and this is showing as DT_NUMERIC (38,0) in the metadata.
July 31, 2008 at 10:03 am
#851376