https://community.qlik.com/t5/Talend-Studio/How-to-open-db-connection-without-opening-transaction/m-p/2375492#M137902 <P>Hi,</P><P></P><P></P><P>I'd like to open a db connection to MS SQL Server but without opening transaction:</P><P></P><P></P><P><U>Job Example</U></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000L1l91AAB.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136904i7F4CB54895389D43/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000L1l91AAB.jpg" alt="0695b00000L1l91AAB.jpg" /></span></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000L1l9GAAR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156612i3F36D34849266B7F/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000L1l9GAAR.png" alt="0695b00000L1l9GAAR.png" /></span></P><P></P><P></P><P></P><P></P><P>Input files have many lines and I don't want to open a transction during the process of all the lines.</P><P></P><P></P><P>Thks for your help</P><P></P><P></P><P></P><P></P> Fri, 15 Nov 2024 23:29:25 GMT Fernandez 2024-11-15T23:29:25Z https://community.qlik.com/t5/Talend-Studio/How-to-open-db-connection-without-opening-transaction/m-p/2375492#M137902 <P>Hi,</P><P></P><P></P><P>I'd like to open a db connection to MS SQL Server but without opening transaction:</P><P></P><P></P><P><U>Job Example</U></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000L1l91AAB.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136904i7F4CB54895389D43/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000L1l91AAB.jpg" alt="0695b00000L1l91AAB.jpg" /></span></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000L1l9GAAR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156612i3F36D34849266B7F/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000L1l9GAAR.png" alt="0695b00000L1l9GAAR.png" /></span></P><P></P><P></P><P></P><P></P><P>Input files have many lines and I don't want to open a transction during the process of all the lines.</P><P></P><P></P><P>Thks for your help</P><P></P><P></P><P></P><P></P> Fri, 15 Nov 2024 23:29:25 GMT https://community.qlik.com/t5/Talend-Studio/How-to-open-db-connection-without-opening-transaction/m-p/2375492#M137902 Fernandez 2024-11-15T23:29:25Z https://community.qlik.com/t5/Talend-Studio/How-to-open-db-connection-without-opening-transaction/m-p/2375493#M137903 <P>Hello,</P><P>There is a <A href="https://help.talend.com/r/en-US/7.3/mssql/tmssqlclose" alt="https://help.talend.com/r/en-US/7.3/mssql/tmssqlclose" target="_blank">TalendHelpCenter: tMSSQLClose</A> Component which you can use to close connections you've opened with tMSSQLConnection.</P><P>Let us know if it is what you are looking for.</P><P>Best regards</P><P>Sabrina</P><P>&nbsp;</P> Thu, 25 Nov 2021 03:57:32 GMT https://community.qlik.com/t5/Talend-Studio/How-to-open-db-connection-without-opening-transaction/m-p/2375493#M137903 Anonymous 2021-11-25T03:57:32Z