ms sql to mysql insert data into table error

[Garrett]

hello,

i am using tdinput and tdouput and trying to insert data from ms sql to mysql into a table into mysql with two columns that i have created the table for in mysql. i am receiving the following error:

Error in the component's propertiesstmt_tDBOutput_1 cannot be resolved
batchSizeCounter_tDBOutput_1 cannot be resolved to a variable
batchSize_tDBOutput_1 cannot be resolved to a variable
batchSizeCounter_tDBOutput_1 cannot be resolved to a variable
pstmt_tDBOutput_1 cannot be resolved
batchSizeCounter_tDBOutput_1 cannot be resolved to a variable
pstmt_tDBOutput_1 cannot be resolved
batchSizeCounter_tDBOutput_1 cannot be resolved to a variable
pstmt_tDBOutput_1 cannot be resolved
batchSizeCounter_tDBOutput_1 cannot be resolved to a variable
pstmt_tDBOutput_1 cannot be resolved to a variable
pstmt_tDBOutput_1 cannot be resolved

[Anonymous]

Hi Garrett,

    Could you please share the overall job screen shot and the component screenshot where you are getting error? I believe you have not added columns inside schema but without screen shots, I will not be able to investigate further.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Garrett]

here are the screenshots:

[Anonymous · Accepted solution]

Hi,

    Could you please add your query inside double quotes? (something like below screen shot)

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Garrett]

thank you. that seemed to resolve my issue.