Error: <target>.ColumnName and <source>.ColumnName have conflicting properties: DataType property mismatch

Use MissingSchemaAction.Ignore as MissingSchemaAction parameter in Merge

table1.Merge(TempTable, True, MissingSchemaAction.Ignore)