Connector Failing With a Row Size Limit Error

Issue

One or more connectors are failing with the error:

Cannot create a row of size xxxxx which is greater than the allowable maximum row size of 8060.

Environment

Destination: SQL Server

Resolution

To resolve this error, you can:

• either break the table into smaller parts where the row size is less than 8060 bytes
• or migrate your data to a warehouse that doesn't have this limitation

Cause

SQL Server has a limit of 8060 bytes per row. For more information on this and other limitations, see SQL Server documentation.