Truncate a table/SQL Scripts in SQL

[Nick_M]

Hi
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.
Thanks

[Anonymous]

I think tMSSqlRow is the way to do that.
Check out this post for a technique using MySQL, maybe you can adapt to your needs:
http://bekwam.blogspot.com/2011/02/running-file-of-sql-statements-with.html