We're running SSIS 2008, moving data from an Oracle 10g database to a SQL 2008 database. The SSIS is running on the same machine as the SQL Destination server. The server has 8 gigs and is windows 2003 sp2
The issue we're having is when our package pulls a blob data type from oracle it will just quit with no errors at about 1.4 million records. We know there are 6 millions records in the dataset.
A friend of mine said it was a NUMA Memory issue that it is running out at some point and SSIS thinks the incoming data is finished. Unfortunately, she said there was no answer.
I was wondering if someone else had a simliar situation moving blobs from Oracle?
View Complete Post