May 9, 2012 at 3:35 am
Hello All,
I am facing this strange issue.
I have created a table in Oracle database given required grants for select and insert (Verified with executing both select and insert queries on the table).
Same table is being used in Execute SQL task where I am passing a input parameter to the query.
For Execute SQL task I have set 'result set' property : none
In Parameter mapping I have done settings for the input parameter.
Connection Type: OLE DB
but when I execute it from SSIS I get this error:
"failed with the following error: "ORA-00942: table or view does not exist". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameter not set correctly, or connection not established correctly."
Any idea??
Thank you,
Shailesh
May 9, 2012 at 3:55 am
shailesh.thapliyal (5/9/2012)
Hello All,"failed with the following error: "ORA-00942: table or view does not exist". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameter not set correctly, or connection not established correctly."
I believe you have installed the Oracle client on the SQL Server box. Have you tried executing the select command from SQLPLUS for the table you mentioned.
Also, ensure that you are putting the valid schema name over there in the query.
If the select staement works fine from SQLPlus, it should work fine within SSIS also.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply