Execute T-SQL Statement Task
Using the Execute T-SQL Statement task, you can run Transact-SQL (T-SQL) statements against specified database. This task supports only the T-SQL version of the SQL language and cannot be used to run statements on the servers that use other dialects of the SQL language. The Execute T-SQL Statement task cannot run parameterized queries and cannot save result sets to variables. This task is mainly designed to run T-SQL commands that can be used to maintain SQL Server. SSIS provides many other maintenance tasks for SQL Server; however, in certain situations you may find this task quite handy and easy to configure to achieve the desired results quickly and efficiently.
This task is quite simple to configure as you can ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
