ORA-00942 Table or view does not exist

Beacon77 131 Reputation points
2022-05-25T15:29:12.167+00:00

Hi All,
I have a Execute SQL Task and the SELECT statement works fine in SQL Developer and Connection works fine but when i execute the task , it fails with the error
[Execute SQL Task] Error: Executing the query "SELECT CAST(COUNT(1) AS VARCHAR2(50)) TBL_COUNT FR..." 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, parameters not set correctly, or connection not established correctly
Please advice.
Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,642 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 40,511 Reputation points
    2022-05-26T02:49:31.877+00:00

    Hi @Beacon77 ,

    Please double check if the table or view name is correct.

    Also check you have set the parameter and resultset correctly.

    execute-sql-tasks-in-ssis-output-parameters-vs-result-sets

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Beacon77 131 Reputation points
    2022-05-26T16:13:07.407+00:00

    Thanks All,
    DBA Renamed the VIEW and we were not notified , thanks a lot and I forgot to refresh the connection.

    1 person found this answer helpful.

  2. Olaf Helper 45,881 Reputation points
    2022-05-27T05:38:14.5+00:00

    ORA-00942: table or view does not exist

    That ORA error message is raised by the Oracle database engine, not by SSIS.
    And in any case of any double Oracle is right and the table don't exists, because you connected to a wrong database or a typo in table name / wrong case on name.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.