March 5, 2009 at 4:42 pm
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?
March 5, 2009 at 7:28 pm
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
March 5, 2009 at 7:47 pm
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