Forum Discussion
Copying from Auzre SQL Server to Lakehouse using DataPipeline
Based on my experience, I would look for a column name with a whitespace in your source.
Microsoft EmployeeHi TendaiQA
Thanks for using Microsoft Fabric Community.
The error message you are encountering in the Microsoft Fabric Pipeline copy activity is due to the presence of invalid characters in a column name.
ErrorCode=DeltaInvalidCharacterInColumnName: This code specifies the error is related to an invalid character in a column name.
Message=Column name inactive contains invalid characters. ",;{}()\n\t=" are not supported.: This clarifies that the column named "inactive" has characters that aren't allowed in Fabric for column names. The specific characters listed are: ",;{}()\n\t="
Troubleshooting steps: The column named "inactive" in your data has characters that aren't allowed in column names at the destination. The specific unsupported characters are ",", ";", "{", "}", "(", ")", "\n", "\t", and "=".
Try to rename the "inactive" column in your destination table to remove the unsupported character. Adhere to your destination database's naming conventions. Consider using underscores (_) or hyphens (-) as separators if needed.
I hope this information helps. Please do let us know if you have any further questions.
Thanks.
- v-cboorla-msft
Hi TendaiQA
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks.