June 8, 2011 at 1:00 pm
My source folder contains the one zip file & XLS file. I will be processing the zip & XLS file, if its existing.
Incase if it’s not available in source folder or already process then I need not to execute the next process.
If no file exist in source folder, a mail should be sent out.
I have written script task to check FileExists in source path. But I’m unable to handle it.
I have handled in the precedence constraint @[bolFileExists]==True ( will execute the execute process task for unzip the file)
another path precedence constraint set to @[bolFileExists]==False( will execute the another part(else part) of script task for showing message(like file not source path) / send mail mail task.
But package trying to execute the execute process task, even thought if i do not have file in source path. Finally throws error. It should not execute the process task.
Any ideas on how I can do this.
Thanks.
June 8, 2011 at 1:37 pm
Please include a screen shot of the control flow - perhaps just after it has failed to demonstrate where it failed.
Also include the text of the error.
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
June 9, 2011 at 2:08 am
Are you sure the value is being set correctly? Can you see it in a Watch?
Did not perhaps set the Evaluation Operation to "OR"?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply