SQL Server Linked Server to Oracle problem

SQL Server Linked Server to Oracle problem


While trying to import a database in Integration Studio i got the following error:
The Ole DB Provider for linked server null reported an error. One or more arguments were reported invalid by the provider

This database is defined in SQL Server as a a linked server to an Oracle database. After google for the error, It seems that is directly related to the way the query is done. Any suggestions on how to fix this problem?
Hi Pedro,

Maybe that is related to the permission of the user OSRuntime user (or HubRuntime).
Please check these 2 posts:

Error creating Extention

Integration studio: problem importing from a linked server

Tiago Simões