How to conditionally create Flat File Destination for Lookup Redirects

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