• Thank you . it worked.

    I had to re-generate the connection within the package for Iseries ODBC. I deleted the old connection and created again , it worked.

    Apperciate your help.