UserErrorInvalidColumnMappingColumnNotFound

Question

Today I'm mapping with 5 columns, but the 5 column only exists when there is an error.
It is an error column, if the process works perfectly this column does not exist.

It is possible to create an IF inside the add dynamic content validating, to force the column to exist and if it has value, fill in it.

Answer 1

When there is a column in the source that isn't in the target you get this error:

UserErrorInvalidColumnName,'... Message=The column <xyz> is not found in the target side.....'

Where <xyz> is the name of the column in the file that isn't in the target table

Note that the error in this question is a little different:

UserErrorInvalidColumnMappingColumnNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column name <The database column> cannot be found in either source data or column mapping

We discovered that the issue was that the source column had a different case

So for example colum in file was

myColumn

But the column in the db was

MyColumn

I don't know why you don't get the standard "column not found" error here.