Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL SSIS to Oracle Table Error

638478Jun 18 2008 — edited Jun 18 2008
Hi All,

I'm trying to execute a SQL SSIS package that will insert data into a few Oracle 10g tables. I'm running into validation warnings on most all of them due to column page code.

Here is the error:

Data Flow Task: OLE DB Destination [1]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

I'm thinking this has to do with SQL data types to Oracle datatypes. Here is one table example of the columns that are matched up.

SQL Oracle
INT Number(28)
Varchar(6) Varchar2(6)
Char(1) Varchar2(1)
Varchar(25) Varchar2(25)
INT Number(28)
DateTime Date

Is there one that jumps out that won't work?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2008
Added on Jun 18 2008
2 comments
1,647 views