how to exit clean from for loop in ssis

[newssis]

Hi all,

I have package that works fine. the process it is doing is:

it process the excel file and i have for loop in that. once as the process runs on files it also put file to archived folder. but the problme happens that it fails everytime when it cannot find the file in the source folder. I want to make it clean exit when file is not there.

Thanks
Pat

 

[MDXer]

Add a OnError COntrol flow to some type of task such as an email to report the failure of a sl task to log it to a table. The make sure your properties don't fail the package on an error.

 

[newssis]

error i get is the file not exist. but the file (any excel) file is process and then it looks for next fine which is not exist. so at then package need to quit succesfully!!