I built a replication package for QuickBooks Online -- I'm replicating data between QBO and a SQL Server data warehouse.
In the replication for the dbo.Customer, I got approx. 40 errors that the field "CompanyName" would be truncated.
Confused over why this would happen, since for the initial run of the replication pakcage I had specified "Create Tables" on the Target Server.
The resulting created table defines CompanyName as nvarchar(50), but there are several records where CompanyName exceeds 50 characters.