I have found the option in 2014 to "Check for object existence", and it includes both a check on the DROP and the CREATE, but this then changes the behavior...

Ah, gotcha. You are correct. I would not be able to write to the AS400 source. I could only write to the SQL server and the MySQL server.

The source tables reside on different servers. One server is AS400 (6 tables, many contain over 10 million records), one server is MySQL (one table). SQL Server 2008 is my...

Ok, so after some further testing (and some help from a coworker), I have discovered that this is apparently caused by the fact that I am using LookupSet to look...