Phil Parkin (6/3/2014)
I suggest you change your approach slightly.Create a FOREACH container which executes for every occurrence of the file you want to process. It will therefore execute either once or not at all.
Put your processing logic inside the FOREACH container.
The package will complete successfully and do nothing if the file is not found.
+1 on this approach.
If you really want to use the script task, you can simply set a status in an SSIS variable. You can use this variable in a precedence constraint to the rest of the package.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP