• I think it has more to do with DB2 then with SQL Server or SSIS, so you should probably check out your source.

    Probably an issue with QUERYTIMEOUTINTERVAL.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP