| David Baldauff 2006-03-24, 8:25 pm |
| Hi,
I am currently attempting to use th Import/Export wizard in SSIS to export
an entire schema (250+ entities) to a SQL Server 2005 database. I'm using
the Microsoft OLEDB Oracle provider.
I get the following error during the spot where it actually attempts to
insert the data:
[Source 50 - TABLENAME] Error: An OLE DB error has occurred. Error code:
0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB
Provider for Oracle" Hresult: 0x80004005 Description: "Unspecified error".
An OLE DB record is available. Source: "Microsoft OLE DB Provider for
Oracle" Hresult: 0x80004005 Description: "ORA-01000: maximum open cursors
exceeded ".
On the Source Connection I have set RetainSameConnection
= True, and I have
set the OLE DB Services to ResourcePooling.
I believe at this point that I need to force my Data Flows to execute
sequentially in order to avoid this error. I'm not real sure what the best
way to do that would be at this point. Please let me know if I am correct,
and what options I have at this point.
Thanks in advance.
|