2

I am trying to Execute the following query using an Execute SQL Task using an Excel connection:

sonu babu
  • 31
  • 2
  • 1
    Hello! Welcome to StackOverflow. Would you please format your question, so that error codes and all is formatted as code? Moreover, could you please provide some context, structure of database, etc? – Joël Feb 20 '19 at 09:55

2 Answers2

1

Executing SQL Query over Excel files is done by the Microsoft Access Database Engine which has many limitations.

Referring to the following article:

Cause

This problem occurs because Access 2007 has a 16-join limit. Additionally, large and complex query criteria in the WHERE clause can cause the "System Resource Exceeded" error message.

Workaround

To work around this problem, change your query so that there are no more than 16 joins.

Community
  • 1
  • 1
Hadi
  • 36,233
  • 13
  • 65
  • 124
0

  1. Check if the Connection String is passed correctly or not.

  2. Check if the Input and Output parameters are configured correctly or not.

  3. Check if the result set parameters are binded correctly or not.
Srikar mogaliraju
  • 215
  • 1
  • 10
  • I have checked these things. Also, if i make the SQL statement shorter (by removing some UNIONS) then it is working fine.Still not able to figure out what exactly the error is. – sonu babu Feb 20 '19 at 13:18
  • If that is the case then you are left with only trail and error method. Remove one union per each execution and check after which union removal the package gets executed successfully. – Srikar mogaliraju Feb 20 '19 at 14:16