error redirect to one file

Hi!

I have several lookups in my data flow task and for each of these I want to redirect error to one file (append data)

I created Flat File connection manager and first lookup goes fine with errors redirected to the file.

However, second error redirect that I am sending to the same file is failing.

Error I get is:

"[Flat File Destination 1 [14851]] Warning: The process cannot access the file because it is being used by another process.”

So my goal is to have one central file where I would redirect all records that fail.

thanks

Take all of the lookup error outputs and combine them with a union all component. Then, from the union all component go into your flat file destination.sql