Forum Discussion
Solved
Copying from Auzre SQL Server to Lakehouse using DataPipeline
Good day, Team I followed the steps here :https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-move-data-lakehouse-pipeline The DB has 280 tables with multiple columns. From the la...
Based on my experience, I would look for a column name with a whitespace in your source.
Based on my experience, I would look for a column name with a whitespace in your source.
Thank you. I just picked it up. There were only a few column names with whitespace causing the error.
At DB level l ran this query
USE [Target Db];
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'Inactive';Then iterated getting the column names from the error logs. I wonder if there a way to prevent it in the near future.
