HY010 Oracle ODBC Function sequence error in SSIS?

2
votes

I created an SSIS package to copy data from one Oracle table to another Oracle table. Each table is in a different database.

I'm getting this error for every single column of the source table:

ERROR [HY010] [Oracle][ODBC]Function sequence error

This is the screenshot.

enter image description here

I have no idea what this means. I've also researched but I haven't seen anything that has helped me.

How can I fix this? I did read that an alternative is to create a linked server.

I wanted to add that the ODBC driver was created with a relatively recent Oracle 12 driver, so I'm not sure why VARCHAR2 columns would not be supported.

Also wanted to point out that the Windows server where the Oracle DB is 64-bit (Windows Server 2008) and Visual Studio 2008 (where the SSIS package is created) is 32-bit. That's why the driver has "_32" at the end.

1
oraclessisodbcetlssis-2008
Why not using OLE DB? - Hadi
I don't have the choice of an ODBC data provider with OLE DB. - fdkgfosfskjdlsjdlkfsf
What is the columns metadata? if VARCHAR2 what is the columns length? - Yahfoufi

1 Answers

0
votes

Based on the following documentation:

The error occurs when ODBC functions are called out of the order required by the ODBC Specification. The error can also occur if an ODBC function call returns an error and the application continues making ODBC calls that require the previous ODBC call to succeed.

I think you should check that all columns data types are supported by the ODBC driver.

Similar questions

Update 1

You can refer to the following link to learn more about supported data types:

Note that in the link above they mentioned that:

If a table contains a column whose data type is not supported by Oracle Database Gateway for ODBC, the column information is not returned to the Oracle database.