What causes SqlAutoCreateTableTypeMapFailed?

A source column has a data type that ADF cannot automatically map to a SQL Server type (e.g., complex JSON, custom binary). The source schema contains a column with an unsupported precision or scale combination. A column name in the source contains characters not allowed in SQL Server column names

How do I fix SqlAutoCreateTableTypeMapFailed?

Disable auto-create table in the copy activity sink and manually create the destination table with the correct schema.. Review the source schema and identify the column type that failed to map — convert it to a compatible type in the source transformation.. Use a data flow transformation before the copy activity to cast unsupported types to SQL-compatible equivalents.

Medium severitydata source

Power BI Refresh Error:
SqlAutoCreateTableTypeMapFailed

What does this error mean?

ADF could not auto-create the destination SQL table because it could not map one or more source column types to SQL Server types.

Common causes

1A source column has a data type that ADF cannot automatically map to a SQL Server type (e.g., complex JSON, custom binary)
2The source schema contains a column with an unsupported precision or scale combination
3A column name in the source contains characters not allowed in SQL Server column names

How to fix it

1Disable auto-create table in the copy activity sink and manually create the destination table with the correct schema.
2Review the source schema and identify the column type that failed to map — convert it to a compatible type in the source transformation.
3Use a data flow transformation before the copy activity to cast unsupported types to SQL-compatible equivalents.

Frequently asked questions

Does this error affect all pipeline runs or just the current one?

Depends on the root cause. A persistent misconfiguration fails every run; a transient issue may resolve on retry. Check the run history.

Can this error appear in Azure Data Factory and Microsoft Fabric pipelines?

Yes — the same connector errors appear in both ADF and Fabric Data Factory pipelines.

How do I see the full error detail for an ADF pipeline failure?

In ADF Monitor, click the failed run, then the failed activity. The detail pane shows the error code, message, and sub-error codes.

Will downstream Power BI datasets be affected when an ADF pipeline fails?

Yes — a dataset refreshing after the pipeline will use stale data or fail if the target table was cleared. The Power BI refresh may succeed while serving wrong data.

Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-synapse-sql