• Thanks Welsh for your help.

    When I set the job to run package as 32 bit then it started working fine. 🙂

    this package connecting to remote MYSQL Server to pull the data.

    Thanks John and every one.