I encountered this error this morning on an SSIS ETL package that had not changed, the source Excel file had not changed, and the target SQL Server table had not...
I have struggled with this in the past and have created a step by step document (attached) showing how you can create a linked server to the iSeries (or AS/400).
We had a situation where a scheduled job invokes a stored procedure that will refresh an SQL Server table from a corresponding DB2 table on an i5 (or AS400 if...