Many thanks Benjamin,

For some relason when I initially attempted this I couldn't get to work but will retry and confirm.

We subsequently came across a bigger issue in that when trying to run a multiple insert with the ~45K records required (with intention to do as a weekly process) that this would far exceed what I understand to be a character limit for the DDLImport query size.

Am therefore going to look at using the SQL Outbound Adapter to try to achieve this and will post results back again regarding in hope might be useful for others.