https://community.qlik.com/t5/Talend-Studio/tMySqlOutput-vs-tMySqlOutputBulk/m-p/2333987#M102713 Hello ... <BR />one more problem <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR />I'm loading date into my DB, <BR />in the data file, date is like yyyyMMdd format. 20110830 for eg. <BR />when i use tMySqlOutput, it is loaded into DB just fine. <BR />but when I use tMySqlOutputBulk, date is not loaded into DB instead, it is showing 1/1/0001 12:00:00. <BR />but in the file generated from tMySqlOutputBulk, the date is showing 30-08-2011. <BR />What is wrong in this scenerio???? <BR />did i put the wrong format??? <BR />please help me... <BR />Thank You. Wed, 31 Aug 2011 09:33:41 GMT Anonymous 2011-08-31T09:33:41Z https://community.qlik.com/t5/Talend-Studio/tMySqlOutput-vs-tMySqlOutputBulk/m-p/2333986#M102712 Hi, <BR />I am using talend for loading data from .dat file to MySQL 5. <BR />My process flow is that I read from the .dat file, validate it and load it into MySQL. <BR />I'm using tMySqlOutput to load into DB. <BR />Last week, I found out that there is one more component <BR />called tMySqlOutPutBulk and tMySqlOutputBulkExecto load into DB. <BR />Can you suggest which one is faster???? in terms of performance??? <BR />and what is the difference between these components?? <BR />Thanks. Sat, 16 Nov 2024 12:42:43 GMT https://community.qlik.com/t5/Talend-Studio/tMySqlOutput-vs-tMySqlOutputBulk/m-p/2333986#M102712 Anonymous 2024-11-16T12:42:43Z https://community.qlik.com/t5/Talend-Studio/tMySqlOutput-vs-tMySqlOutputBulk/m-p/2333987#M102713 Hello ... <BR />one more problem <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR />I'm loading date into my DB, <BR />in the data file, date is like yyyyMMdd format. 20110830 for eg. <BR />when i use tMySqlOutput, it is loaded into DB just fine. <BR />but when I use tMySqlOutputBulk, date is not loaded into DB instead, it is showing 1/1/0001 12:00:00. <BR />but in the file generated from tMySqlOutputBulk, the date is showing 30-08-2011. <BR />What is wrong in this scenerio???? <BR />did i put the wrong format??? <BR />please help me... <BR />Thank You. Wed, 31 Aug 2011 09:33:41 GMT https://community.qlik.com/t5/Talend-Studio/tMySqlOutput-vs-tMySqlOutputBulk/m-p/2333987#M102713 Anonymous 2011-08-31T09:33:41Z