Craig,

You can use the script component as the error destination after any transformation (that has an error output) within the data flow. Then I immediately insert into the logging table.

So you can have a source then a lookup transform. In your lookup transform you set the error output to the script component then the script component output to an oledb datasource. Then you have a destination with an error output to a script component which has an output to an oledb destination. Attached is a screenshot of a data flow in my project which has 4 script components for error logging with 4 oledb destinations.

Hope this helps.