Thanks for the responses.

Yes I tried BCP but have to include headers. I used the UNION ALL approach to add the hedrers but this failed due to data type differences.

In the meantime I am trying the approach in the first response.