• Also make sure that the job owner is "sa" or some other user with sufficient privileges. Also ensure that the SQL Server/Agent startup account has privileges on the folder\files that are being referred in the SSIS package.

    Other option to troubleshoot this issue would be to logon to the server with the credentials of the SQL Server service account and then execute the SSIS package manually.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga