Execute T-sql Statement Task

The execute t-sql statement task runs transact-sql statements. This task is similar to the execute sql task. However, the execute t-sql statement task supports only the transact-sql version of the sql language and you cannot use this task to run statements on servers that use other dialects of the sql language. 

Step 1:

Drag and drop execute t-sql statement task and edit it. Give a connection as execute t-sql statement task. 

Step 2:

In T-Sql statement write a simple query as

BEGIN

SET NOCOUNT ON;

TRUNCATE TABLE DimEmployee

END

Step 3:

Click on View T-SQL

Step 4:

Execute a task