December 8, 2010 at 9:10 am
I am transferring data from Oracle to SQL Server using SSIS and I am running into a few issues between oracle and SQL.
1st - Some of the data types in Oracle do not come into SQL very good. I get errors stating it is unicode and cannot convert when the Oracle data type is a varchar2 or date (not unicode).
In these cases I have to switch from an OLE DB connection to ADO.
2nd - When using an ADO connection the variable functionality is gone in the Control Flow. For the project I am working on we are pulling in records from the max date in the table stored in a variable.
So why is SQL not wanting to bring in a date or varchar2 when neither are unicode and should not have to be converted?
Here is one of the error messages from SSIS:
"OraOLEDB" Hresult: 0x80040E14 Description: "ORA-00904: "TEV2"."DISPLAY": invalid identifier".
[SSIS.Pipeline] Error: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.
"TEV2"."DISPLAY": is a varchar2 data type
Thanks for any help
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply