additional column in schema of tMSSqlOutputBulkExec

[Anonymous]

Hello,

I am fetching some millions of rows from MySql and loading it into SQL server using bulk insert (tMSSqlOutputBulkExec) component. 

The issue is in edit schema I can add only those columns which are in the source(input) I cannot add any additional column in target side schema if I do that I get below error

tMSSqlOutputBulkExec_7_tMBE Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (<name of new column>)

I even tried to insert that new column first in SQL server directly and then keeping the same schema in component still it fails with above error.

Can anyone please help.

Talend Data Fabric 6.3.1

Java 8 

[Anonymous]

Out of curiosity, have you tried to add the new column with a tMap in the middle or straight on the Output component?

[Anonymous]

Hi,

    Could you please share a screen shot of the job you are creating so that we will get more idea about it?

Warm Regards,

Nikhil Thampi

[Anonymous]

No tMap direct row(main) connection between tAmazonMySqlInput and tMSSqlOutputBulkExec. Can we solve this problem using tMap, if yes then how?

design.jpg

[Anonymous · Accepted solution]

Hi,

      If you add a tmap, you will be able to customize the list of columns required in output flow. 

      If you are having 5 input columns and you would like to have 6 columns in the output, then you should use the tmap to map between source and target columns.

      The best way to learn tmap is to practice the scenarios mentioned in the tmap.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/mxzKD~8eLuNFSXH6LMi7qg

Warm Regards,

Nikhil Thampi

[Anonymous]

Thank you @nthampi adding tmap solved the issue.

[Anonymous]

Happy to help you.

Enjoy Talend 🙂

Warm Regards,

Nikhil Thampi