I have privs to truncate a table in MS Visual Studio, but I can not do this inside of my fex. The MSSQL connector is set up with the same account. I have tried the following:

ENGINE SQLMSS SET DEFAULT_CONNECTION LOAD_DATA
SQL SQLMSS
BEGIN TRANSACTION;
TRUNCATE TABLE BISSVTNAS;
COMMIT;
END
-RUN

I don not get an error.

This message has been edited. Last edited by: <Kathryn Henning>,

I have successfully truncated MS SQL Server tables without wrapping the command in a transaction:

SET SQLENGINE=SQLMSS

ENGINE SQLMSS SET DEFAULT_CONNECTION autumn

SQL
TRUNCATE TABLE apple.bushel;
END

BigE, I suspect that you have too many commands with semicolons, it probably never got to the TRUNCATE command.

Francis' post only has the one command.

Waz is right. here is SQL that truncates multiple tables - no semi-colons:

SQL
TRUNCATE TABLE apple.transaction_tfcdbr
TRUNCATE TABLE apple.transaction_tfcd
TRUNCATE TABLE apple.transaction_tfc
TRUNCATE TABLE apple.transaction_tdbr
TRUNCATE TABLE apple.transaction_td

TRUNCATE TABLE apple.transaction_sfcdbr
TRUNCATE TABLE apple.transaction_sfcd
TRUNCATE TABLE apple.transaction_sfc
TRUNCATE TABLE apple.transaction_sdbr
TRUNCATE TABLE apple.transaction_sd
END

Some time ago I tried running a transaction as SQL passthru and had no luck. My notes suggest it used to work before WF v7.6.