Share via

ISNULL() returning error in ADF copy activity query for SQL server

Rahul Gupta 20 Reputation points
2023-06-20T11:14:37.2966667+00:00

SELECT distinct MDM_COUNTRY_NAME, ISNULL(MDM_TRANS_ZONE,''), MDM_ISO_COUNTRY_CODE FROM dbo.F_MDM_COUNTRIES_4_0 in ADF copy activity query for SQL server is returning the below error

ErrorCode=ParquetInvalidColumnName,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The column name is invalid. Column name cannot contain these character:[,;{}()\n\t=],Source=Microsoft.DataTransfer.Common,'

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer accepted by question author

Naomi Nosonovsky 8,906 Reputation points
2023-06-20T15:24:00.2966667+00:00

Did you try to give an alias to the column, e.g.

SELECT distinct MDM_COUNTRY_NAME, ISNULL(MDM_TRANS_ZONE,'') as MDM_TRANS_ZONE, MDM_ISO_COUNTRY_CODE FROM dbo.F_MDM_COUNTRIES_4_0

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.