Thanks for that - but ideally I don't really want to introduce another staging table.

I'm going to start reading about the "Conditional Split" that you can use in SSIS to see if this will help. I just have no idea how to use it yet.

Any other suggestions are welcome.

Thanks again.