Truncate a table/SQL Scripts in SQL

One Star

Truncate a table/SQL Scripts in SQL

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
Four Stars

Re: Truncate a table/SQL Scripts in SQL

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