Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
ERROR [HY000] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0666 - SQL query exceeds specified time limit or storage limit

Answered 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
     
     
    Sign In to Vote
    0

    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

     

All Replies