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.