none
ERROR [HY000] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0666 - SQL query exceeds specified time limit or storage limit

    Question

  • I am using SQL query to join 3 tables which has very limited records (less than 1000) to pull data from AS400 datasource.  I get this error when I execute this query using SSIS.  The same query works fine in SQL 2000 DTS.  

    System.Data.Odbc.OdbcException: ERROR [HY000] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0666 - SQL query exceeds specified time limit or storage limit

    Thursday, July 29, 2010 7:52 AM

Answers