On my server box(SQL Server 2012), I use my BISM(in Data Tool) to load one table from oracle DB. The connection was tested successfully but loading data always ends up with the error as below.
Note. Analysis Server has persisted any security information specified as part of the Connection string portion of the Datsource object definition.
The provider 'OraOLEDB.Oracle' is not registered.
The following system error occurred: Class not registered
A connection could not be made to the data source with the DataSourceID of '6faa7257-f404-4dc6-9e22-50663f2cfb30', Name of 'Oracle fff2'.
An error occurred while processing the partition 'APPLICATION_258b4794-870c-46b4-8d81-d4d9a0a4e495' in table 'APPLICATION_258b4794-870c-46b4-8d81-d4d9a0a4e495'.
The current operation was cancelled because another operation in the transaction failed.
Out of line object 'DataSource', referring to ID(s) '6faa7257-f404-4dc6-9e22-50663f2cfb30', has been specified but has not been used.
Out of line object 'DataSourceView', referring to ID(s) 'Temp_DSV', has been specified but has not been used.
Any idea to share on this?
Thanks in advance
Edited byDerek DaiSaturday, September 14, 2013 6:43 PM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.