Data Source Error : DataSource.Error: Microsoft SQL: Error converting data type varchar to bigint

[debiagui]

Hi we're creating a dataflow connected to a MySql server using a personal Gateway.

In this dataflow we have two primary tables, one transactional (also with an incremental refresh) and one for master data.

We like to create a merged new table with the combination between both tables, and in the new table perform some calculations.

Transactional Table columns:

Master Data table columns:

The New table will include a multiplication of Transactional Valor (only 0 or 1) and MD Valor (a number range between 0 and 1)

But after save my dataflow I've the error:

Data Source Error : DataSource.Error: Microsoft SQL: Error converting data type varchar to bigint.-

Any ideas about it?

[debiagui · Accepted solution]

Dismiss it, one of the data inside of the MatrizKey was malformed as numeric, but the Query syntax not show the error, and the column qualilty also not show the bad format.-