Slowly changing Dimension is not working with Oracle

• venkatesh-MSBI

  Mr or Mrs. 500

  Points: 522

  More actions

  September 17, 2009 at 1:08 pm

  #135718

  hi

  This is Venkatesh. I am facing one issue in Slowly changing Dimensions. For me Source is from SQL Server 2005 (i.e., OLEDB Source -- i used Microsoft Oledb Provider for SQL Server) and destination is Oracle 10g (i.e., Microsoft Oledb provider for Oracle).

  Scenario:

  OLEDB Source (SQL Server 2005) --- Slowly changing Dimension (oracle 10g) . Am not getting the params in oledb command control. I added manually in the OLEDB Command. Still it is not working.

  hi

  Actual error is :

  TITLE: Microsoft Visual Studio

  ------------------------------

  Error at Sample - Data Flow Task [OLE DB Command [2596]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E51.

  An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E51 Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.".

  Error at Sample - Data Flow Task [OLE DB Command [2596]]: Unable to retrieve destination column descriptions from the parameters of the SQL command.

  Warning at {96B6D7AA-9AFF-41F5-B802-50AE37872DCB} [Insert Destination [2556]]: 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.

  ------------------------------

  ADDITIONAL INFORMATION:

  Errors were encountered while generating the wizard results:

  Error at Sample - Data Flow Task [OLE DB Command [2596]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E51.

  An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E51 Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.".

  Error at Sample - Data Flow Task [OLE DB Command [2596]]: Unable to retrieve destination column descriptions from the parameters of the SQL command.

  Suggest me if anyone knows the solution.

  Thanks & Regards

  Venkatesh