8. Found more columns than expected | Common Errors in ADF

[@ComedyXRoad]

could you make a video on optimisation in adf . thank you

[@bababallon1785]

If we got one extra column from source for one or two rows and these rows doesn't have the column header, How to we process these records into one extra column

[@asianand4885]

We use alter table on SQL side and add those required columns which are not present while copying data from some source to SQL.

[@azurecontentannu6399]

But in this scenario, it's single column value which is getting treated as multiple column due to Comma separated value present, eg: 'Delhi, India' . To mitigate this, we need to configure quote character in source dataset correctly. Thankyou

[@asianand4885]

@@azurecontentannu6399 yes agree what you have shared. I shared a real time use case of my project.