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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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