I'm attempting to push data from SQL via SSIS DT_TEXT to an oracle CLOB field, but performance is utterly horrendous.
It's currently migrating the data at 400 rows per min.
my requirement is to migration 5 million rows - so approximately 210 hours at present - which is not do-able.
I've taken an average row size and set the default buffer max rows. I'd also set out with the intention of using Attunity drivers, but CLOB is not supported in SQL 2008 R2.
Has anyone else pushed data to oracle and do you have any performance tuning tips /ideas I can try?
as always - your time and help are greatly appreciated.
MCITP: Business Intelligence Developer (2005)