After I switch my package to "Use new runtime," I get the following error about the destination database: "Package failed: Table 'dbo.namb_accountmembership' does not exist in the database."
With the old runtime, it was using the tables in a different schema that I chose, the "crm" schema not the "dbo" schema. This worked because I changed the default schema for the database login to "crm". However, the new runtime is trying to force the tables to be in the "dbo" schema.
The source is Dynamics CRM and the destination is Azure SQL.