Pipeline copy activity failed while copying data from .csv to azure sql

Question

Hi,

Pipeline copy activity failed while copying data from .csv to azure sql ,

can any one help me out  to get this solved

below is the error description,

with row number 2: found more columns than expected column count: 56.,Source=Microsoft.DataTransfer.Common,'

Thanks in Advance

Answer 1

The error means your csv file has more columns than your specified schema.

can you check the number of schema columns in your csv file ? if the number is greater than 56.

if you are using "import schema" for your csv, it may not get the full column information, it will not scan all data for your csv file.

Answer 2

Thank alot