Hi all,
I am redirecting the critical lookup errors to the flat files. These flat files got created regardless if there are lookup errors or not.
Is there a better way to conditionally create them only when there are lookup errors?
Thanks.
Its not really possible, no.
What you could do is count the number of records (using a ROWCOUNT component). Then, probably in the OnPostExecute eventhandler for the data-flow, delete the file if the rowcount is zero.
Or you could push everything into a recordset destination and then, in the eventhandler, push the stuff into a flat file IF the rowcount is greater than zero.
-Jamie
