Hi @Kuldeep Chitrakar ,
I'm not familiar with AS400/DB2.
I did some online research but there is only a little information about this error.
Here is a same issue that The Microsoft OLE DB Provider for DB2 does not return a valid error object on an SSIS OLE DB source that uses SQL Command. This causes Microsoft SQL Server to return an "Accessor is invalid" error message.
Check the resolution to see if it could resolve the issue.
Someone mentioned in this thread said, you may have a try.
When using SQL Server Integration Services with SQL commands containing parameters (WHERE clauses), you must set the optional OLE DB data source initialization property “Derive Parameters” to TRUE. This property instructs the provider to derive parameter information from the data source, upon request of the consumer. You can set this property from the Advanced Options page of the Data Source Wizard, or the All tab of the Data Links dialog. You can specify this property in an OLE DB initialization string (connection string) using the “Derive Parameters=FALSE” argument.
Set this value to TRUE when using SQL Server Integration Services with parameterized statements that include a WHERE clause (e.g., SELECT, INSERT, UPDATE DELETE).
You may take a reference to see if it is helpful.
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.