Just in case - prior to a particular version of CRM (2013 or 2015 I think) all foreign keys were defined as not for replication and were would not be...

While advice is still to contact Microsoft I am sharing an email I exchanged with them (licensing team) last year.

For SQL Server Dev edition and because it is...

Move empty file will move data blocks as they are onto a new file - the main mdf file will still remain as is with system objects - the shrink...

As this is a once off task the "recomendation" not to shrink the files does not apply.
And as this is to go to a new database I assume that...

Why not do the whole merge, sort and exception handling on the database itself?
even if the 2 tables are in 2 different SQL Instances in many cases it will...

Really vague so hard to tell what the issue really is.
No need to change to SSIS - but you may need to change your process a bit depending on...

from my own experience with a few Tabular projects performance will depend mostly on the volume, type of data and cardinality of the data (which also affects compression).

You may be able to get around it on SSRS reports (and eventually powerbi but not sure as Tabular requires Windows Authentication)

1 - Do not grant users access...

using the ACE driver (2010 or 2016) it seems to work fine.
If that isn't what you are using give it a try
https://www.microsoft.com/en-ie/download/details.aspx?id=10910
https://www.microsoft.com/en-us/download/details.aspx?id=50040

Also note that some...

Unless your package is executing a sql statement using linked servers against either A or B with no data flow present then yes it is flowing from A => C...

file seems to be missing a valid value for customerkey - when you preview the data on the source component does it show you values for the customerkey column?
If...