https://community.qlik.com/t5/Talend-Studio/Truncate-a-table-SQL-Scripts-in-SQL/m-p/2330707#M99759 I think tMSSqlRow is the way to do that. <BR />Check out this post for a technique using MySQL, maybe you can adapt to your needs: <BR /><A href="http://bekwam.blogspot.com/2011/02/running-file-of-sql-statements-with.html" rel="nofollow noopener noreferrer">http://bekwam.blogspot.com/2011/02/running-file-of-sql-statements-with.html</A> Wed, 13 Jul 2011 17:22:49 GMT Anonymous 2011-07-13T17:22:49Z https://community.qlik.com/t5/Talend-Studio/Truncate-a-table-SQL-Scripts-in-SQL/m-p/2330706#M99758 Hi<BR />We are importing data into a table in MS SQL. How can we excecute TSQL scripts such as truncate table etc. We have tried using tMSSqlRow and tMSSqlOutput without sucess.<BR />Thanks Sat, 16 Nov 2024 12:48:46 GMT https://community.qlik.com/t5/Talend-Studio/Truncate-a-table-SQL-Scripts-in-SQL/m-p/2330706#M99758 Nick_M 2024-11-16T12:48:46Z https://community.qlik.com/t5/Talend-Studio/Truncate-a-table-SQL-Scripts-in-SQL/m-p/2330707#M99759 I think tMSSqlRow is the way to do that. <BR />Check out this post for a technique using MySQL, maybe you can adapt to your needs: <BR /><A href="http://bekwam.blogspot.com/2011/02/running-file-of-sql-statements-with.html" rel="nofollow noopener noreferrer">http://bekwam.blogspot.com/2011/02/running-file-of-sql-statements-with.html</A> Wed, 13 Jul 2011 17:22:49 GMT https://community.qlik.com/t5/Talend-Studio/Truncate-a-table-SQL-Scripts-in-SQL/m-p/2330707#M99759 Anonymous 2011-07-13T17:22:49Z