ForEachfile container capture "file not found" event

Question

ForEachfile container capture "file not found" event

Uripedes Pants

Hall of Fame

Points: 3701
More actions
May 24, 2012 at 11:35 am

#274435

Hi all -
I'm working error handling in a package and one of the requirements is to log an error when there are no files to process. It seems that the ForEachFile container just quits with success when no files are found. In other error handlers I've put an execute SQL task and written to a table. I need to do the same here, but it's not reported as an error... any ideas?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

Hi again Kevin 🙂

Since you are mapping a variable in your FEL you can use an expression in a precedence constraint to check if the variable was set to something and react appropriately.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Uripedes Pants Hall of Fame Points: 3701 More actions · Answer 2

Hey my friend opc.three!

Just before you replied the lightbulb over my head fired off. I noticed in the output from the package the FEL throws a warning message when there are no files. I put an OnWarning event handler on the FEL container with a SQL script task to log to my errors table. It was one of your earlier responses that got me thinking along that path, so I must be learning something :hehe:

Thanks again for your continued support and tutelage!

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 3

Uripedes Pants (5/25/2012)
Hey my friend opc.three!
Just before you replied the lightbulb over my head fired off. I noticed in the output from the package the FEL throws a warning message when there are no files. I put an OnWarning event handler on the FEL container with a SQL script task to log to my errors table. It was one of your earlier responses that got me thinking along that path, so I must be learning something :hehe:
Thanks again for your continued support and tutelage!

Hey, happy to learn together. I did not know the FELC raised a warning in that case but I am sure that will come in handy down the line. Very good to know and works quite nicely for your use case!

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato