https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315806#M86425 <P>Hi Garrett,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; 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.</P> <P>&nbsp;</P> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 17 May 2019 21:35:48 GMT Anonymous 2019-05-17T21:35:48Z https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315805#M86424 <P>hello,</P> <P>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:</P> <P>Error in the component's properties<span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAB6.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/158321i00588DF41617C922/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAB6.png" alt="0683p000009MAB6.png" /></span>stmt_tDBOutput_1 cannot be resolved<BR />batchSizeCounter_tDBOutput_1 cannot be resolved to a variable<BR />batchSize_tDBOutput_1 cannot be resolved to a variable<BR />batchSizeCounter_tDBOutput_1 cannot be resolved to a variable<BR />pstmt_tDBOutput_1 cannot be resolved<BR />batchSizeCounter_tDBOutput_1 cannot be resolved to a variable<BR />pstmt_tDBOutput_1 cannot be resolved<BR />batchSizeCounter_tDBOutput_1 cannot be resolved to a variable<BR />pstmt_tDBOutput_1 cannot be resolved<BR />batchSizeCounter_tDBOutput_1 cannot be resolved to a variable<BR />pstmt_tDBOutput_1 cannot be resolved to a variable<BR />pstmt_tDBOutput_1 cannot be resolved</P> Fri, 17 May 2019 19:31:33 GMT https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315805#M86424 Garrett 2019-05-17T19:31:33Z https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315806#M86425 <P>Hi Garrett,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; 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.</P> <P>&nbsp;</P> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 17 May 2019 21:35:48 GMT https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315806#M86425 Anonymous 2019-05-17T21:35:48Z https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315807#M86426 <P>here are the screenshots:</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="screenshot1.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4Et.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136311i23E823CB0774987A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4Et.png" alt="0683p000009M4Et.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="screenshot2.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4F3.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140905i89504543B43FE730/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4F3.png" alt="0683p000009M4F3.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="screenshot3.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4FD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157498i31371BD1ABFCE831/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4FD.png" alt="0683p000009M4FD.png" /></span></SPAN></P> Fri, 17 May 2019 22:16:12 GMT https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315807#M86426 Garrett 2019-05-17T22:16:12Z https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315808#M86427 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; Could you please add your query inside double quotes? (something like below screen shot)</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 990px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M45F.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148501i0C6DBA362464765A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M45F.png" alt="0683p000009M45F.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 21 May 2019 21:26:48 GMT https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315808#M86427 Anonymous 2019-05-21T21:26:48Z https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315809#M86428 <P>thank you. that seemed to resolve my issue.</P> Tue, 21 May 2019 21:27:54 GMT https://community.qlik.com/t5/Talend-Studio/ms-sql-to-mysql-insert-data-into-table-error/m-p/2315809#M86428 Garrett 2019-05-21T21:27:54Z