From the course: SQL Server Integration Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

SQL Server tasks

SQL Server tasks - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

SQL Server tasks

“

- [Narrator] We've already seen an example of the Execute SQL task to run a couple of statements that created a table and added a few records. This one task alone will allow you to accomplish most SQL server related activities, since it's so flexible. Previously we entered the SQL commands directly into the task, as something called a Direct Input. You can also link to an external script file on your system, in order to make it easier to modify what the task is doing. Just like before, I want to explore this concept I'll right click SSIS Packages, and choose New Package. And then I'll right click on the new package, and rename it. I'll call this External SQL. Now before we get started, I do want to point out that there's the Execute SQL task up here in the Favorites group, and if you scroll down, you'll find this one here, called Execute T-SQL statement in the Other Tasks group. On the surface, these would appear to do the same thing. The difference is that this one, the Execute…

Contents