• Check if the Job History has any information as to why the job is not proceeding. You may also add an output file to the Job Step to capture more information on job execution.

    Does the SSIS package run fine when not run as a job?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga