Viewing 3 posts - 1 through 4 (of 4 total)
Sorry for late reply. Here is document about loading to Oracle.
I cann't find any link direct to persistent bulk load information but from the forum told that it's very expensive....
May 17, 2012 at 2:29 am
I use data access mode as "Table name or view name variable" which config in OLE DB Destination task.
I try to set the data access mode to "OpenRowset Using FastLoad...
May 13, 2012 at 8:05 pm
There 're 6 million rows of data from mssql server loading to oracel 10g directly. The SSIS package running speed is around 6 - 7 hours before failed while loading...
May 11, 2012 at 10:36 am
Viewing 3 posts - 1 through 4 (of 4 total)