Slowly Changing Dimension [58] Error

i am using SCD to insert or update .my source and destination table are Oracle and i am using Orcale OLEDB provider . i am getting the following error while executing the package.what could be the solution

[Slowly Changing Dimension [58]] Error: An OLE DB error has occurred. Error code: 0x80040E5D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E5D Description: "Parameter name is unrecognized.".

Thanks

Jegan

Hi Jegant,

I have the same problem.

Hi Jwelch,

The SQL is in OLE DBSource:
SELECT ID_FAB, VAL_FABCOD, TXT_FABNAME, TXT_NIT , TXT_EANCOD, ID_COUNTRY, TO_NUMBER(TO_CHAR(sysdate,'J'),999999999) DATE
FROM REP_FAB;

REP_FAB is table in Oracle 9i.

I'm using Slowly Changing Dimension to update/insert in other table in the same data base Oracle 9i.

in the Slowly Changing Dimension have this warning:

Warning: 0x80202066 at MAINCONTROL_FLOW, Slowly Changing Dimension [2667]: 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.

The result of Slowly Changing Dimension is one update OLE DB Command and OLE DB Destination.

The update insert is:

UPDATE "ADMONDB"."MANUFACTURER" SET "NEWDATE" = ,"TXT_EANCOD" = ,"TXT_NAME" = ,"TXT_NIT" = WHERE "ID_FAB" =

Do you need more information

Thanks for your help.

Rdjaramillo.