Thanks for all your answers, I really appreciate it.

I could create a stored procedure to do a select * into, but I feel the transfering of data in SSIS is...

Ok so from the postings:

loop through the tables doing:

1. Script task to create dynamic sql to create the table if it doesn't exist on destination.

2. Run sql against destination OLE...

You've hit the nail on the head "depending on your coding skills"!!!

Thanks again, I will give it a go.

Thanks for the quick response Phil.

I Initially tried using the SQL Server Objects task, but unfortunately it wouldn't work with the databases being in compatibility mode (which we need for...