Fault Tolerance - Skip Incompatible Columns
I am loading data dynamically from multiple SQL Server databases. All of the databases share the same table structure. However, there may be some exceptions where one of the databases has a missing column in one of the tables.
When such a situation occurs, I would like to set the Fault Tolerance on to Skip the incompatible column. Meaning, instead of it failing or skipping all the rows (columns), it should skip the single column instead.
That way, instead of losing all the columns, I lose one column, which is not used anyways since it never exists.
Ed Pearson commented
This looks like has been partially done, but so far only applies to Azure SQL