topic Re: I want to load bulk data in MS SQL in Talend Studio https://community.qlik.com/t5/Talend-Studio/I-want-to-load-bulk-data-in-MS-SQL/m-p/2324303#M94012 <P>Hello,</P> <P>Please take a look at the related scenario about:<A title="TalendHelpCenter:Scenario: Inserting transformed data in MySQL database" href="https://help.talend.com/reader/dbMXwAXLEyMXaq7Fb5Y3Tw/root" target="_self" rel="nofollow noopener noreferrer">TalendHelpCenter: Scenario: Inserting transformed data in MySQL database</A></P> <P>This scenario describes a four-component job which aims at fueling a database with data contained in a file, including transformed data. You can use <SPAN class="ph cmd"> <SPAN class="ph uicontrol">tMssqlBulkExec and tMssqlOutputBulk components to load&nbsp; bulk data in MS SQL DB.<BR /></SPAN></SPAN></P> <P><SPAN class="ph cmd"><SPAN class="ph uicontrol">Best regards</SPAN></SPAN></P> <P><SPAN class="ph cmd"><SPAN class="ph uicontrol">Sabrina</SPAN></SPAN></P> Fri, 10 Nov 2017 09:28:35 GMT Anonymous 2017-11-10T09:28:35Z I want to load bulk data in MS SQL https://community.qlik.com/t5/Talend-Studio/I-want-to-load-bulk-data-in-MS-SQL/m-p/2324302#M94011 <P>&nbsp;I'm having very huge amount of data to load into tables. I want best approach bcp or tmssqlbulkexe</P> Sat, 16 Nov 2024 09:04:42 GMT https://community.qlik.com/t5/Talend-Studio/I-want-to-load-bulk-data-in-MS-SQL/m-p/2324302#M94011 Anonymous 2024-11-16T09:04:42Z Re: I want to load bulk data in MS SQL https://community.qlik.com/t5/Talend-Studio/I-want-to-load-bulk-data-in-MS-SQL/m-p/2324303#M94012 <P>Hello,</P> <P>Please take a look at the related scenario about:<A title="TalendHelpCenter:Scenario: Inserting transformed data in MySQL database" href="https://help.talend.com/reader/dbMXwAXLEyMXaq7Fb5Y3Tw/root" target="_self" rel="nofollow noopener noreferrer">TalendHelpCenter: Scenario: Inserting transformed data in MySQL database</A></P> <P>This scenario describes a four-component job which aims at fueling a database with data contained in a file, including transformed data. You can use <SPAN class="ph cmd"> <SPAN class="ph uicontrol">tMssqlBulkExec and tMssqlOutputBulk components to load&nbsp; bulk data in MS SQL DB.<BR /></SPAN></SPAN></P> <P><SPAN class="ph cmd"><SPAN class="ph uicontrol">Best regards</SPAN></SPAN></P> <P><SPAN class="ph cmd"><SPAN class="ph uicontrol">Sabrina</SPAN></SPAN></P> Fri, 10 Nov 2017 09:28:35 GMT https://community.qlik.com/t5/Talend-Studio/I-want-to-load-bulk-data-in-MS-SQL/m-p/2324303#M94012 Anonymous 2017-11-10T09:28:35Z