Excel to SQL DB Table :Column Space truncated

Question

Hi,

I am facing an issue while copying data from excel to Azure SQL DB, I am using a simple copy activity.

If I have a trailing space at the end of column value, that space is truncated.

for Eg, i have a colun 'client' , and one of the values is 'airtel '....., the last space after l is truncated, I can see only 'airtel' without space. why this is happening? how do I bring the data as is?

Answer 1

Hi @Santhi Dhanuskodi

Thanks for the question and using MS Q&A platform.

As I understand you are experiencing an issue with the Copy Activity in Azure Data Factory where trailing spaces are being truncated when copying data from Excel to Azure SQL DB.

I tried to repro the scenario from my end, and I was able to preserve the trailing spaces before the single quote.

Could you please recheck and try with your data, and then rerun the copy activity with your Azure SQL DB?

Please do let me know, if you have any further queries. Glad to help.

Answer 2

If the table column data type is "varchar", then it's by design that trailing spaces will be truncated.