SSIS Foreeach Container Not Failing I have a foreach container which is looking in a share directory for files to then send on to another location.  When I ran this as part of a job the package was running successfully however the files were not being sent.  The reason was because the agent account needed access to the share.

My question is how can I get the package to fail should it not have permissions to access the directory?

Thanks
Surprise, surprise, surprise!  SSIS doesn't fail the Foreach File loop container if the path is inaccessible – wow... how fun.  You'll have to add a script task to check before the loop fires.