SSIS Tutorial - Execute SQL Task
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis.
You can now support me on patreon - / beardeddev
In this SSIS Tutorial we talk about the Execute SQL Task within the Control Flow, along with the Data Flow Task this will make up 90% of what you will need to do in terms of an ETL process.
We discuss examples on how we can use the Execute SQL Task to Truncate Tables, Execute Stored Procedures with Parameters and run a SELECT statement and return a result set.
This SSIS Tutorial doesn't discuss how to create connection managers, if you are new to SSIS and would like to learn how to create connection managers check out the below videos on my channel:
If you are interested in watching all tutorials and videos on SQL Server Integration Services then check out the playlist available:
On this page of the site you can watch the video online SSIS Tutorial - Execute SQL Task with a duration of hours minute second in good quality, which was uploaded by the user BeardedDev 11 November 2018, share the link with friends and acquaintances, this video has already been watched 15,953 times on youtube and it was liked by 148 viewers. Enjoy your viewing!
