Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Slowly changing Dimension is not working with Oracle Expand / Collapse
Author
Message
Posted Thursday, September 17, 2009 1:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 12:50 AM
Points: 16, Visits: 113
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
Post #789933
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse