SSIS Job failure

  • Hi,

    I have created a SSIS package that deletes backup files with conditions. Some SQL servers backup folders are not same as others and I have created condition on deleting the files.

    First delete files on G:\ with extention with BAK. If successful, deletes files on G:\ with TRN extention. If failes to delete files on G:\ with BAK extention, I have another step to delete files on F:\ with BAK extention. SSIS package works well when I run from SQL Server Business Intelligence Development Studio. But when I run as a SQL job with SSIS package, it fails the whole package on the first condition and fails the whole job rather than moving onto checking second condition.

    SSIS Steps: Delete *.bak files on G:\, on "Sucess", delete *.trn files

    Delete *.bak files on G:\, on "Failure", delete *.bak files on F:\

    Can someone help why the job never goes to second condition and excute the job successfully?

  • Sounds like a permissions issue. Check that the SQL Agent service user has rights to access and delete the files.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • It is not permission issue since I am running a service account which has local admin permission.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply