This is what meltano is trying to execute:

INSERT INTO dbo.localizapessoa (codpes, tipvin, numseqpes, codfncetr, tipvinext, nompes, nomset, codema, numtelfmt) SELECT codpes, tipvin, numseqpes, codfncetr, tipvinext, nompes, nomset, codema, numtelfmt from dbo.localizapessoa_temp temp ON DUPLICATE KEY UPDATE codpes = VALUES(codpes) and tipvin = VALUES(tipvin) and numseqpes = VALUES(numseqpes) and codfncetr = VALUES(codfncetr)

the error is: Column 'tipvin' in field list is ambiguous