Solution is to uninstall SQL Server Integration Services Projects v 4.2 and install 3.16 instead. 4.2 doesn't support the Oracle connector. Make sure you do a reboot after switching.

Hi Jeff,

Thanks for the feedback, it is much appreciated. The table rows are not huge for the most part. All the tables within scope have between 3 and 16...

Having read through some of the articles on archiving on this site it looks as though the preferred approach would be to:

drop foreign key constraints on the target tables

rename...

I wasn't able to get the actual EP from the production system for this, but just wanted to say thank you for the responses. Both suggested solutions were really helpful.

Thanks...

No, I have the XML, just trying to get it to a place where I can upload it - pasting text is easier. I'll try and get that uploaded.

Sorry, forgot this. Please see below.

Execution plan - I tried to paste this in but I keep getting code replaced with smileys:

|--Compute...

Thanks Luis, that was really helpful.