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:
Watch video SSIS Tutorial - Execute SQL Task online without registration, duration hours minute second in high quality. This video was added by user BeardedDev 11 November 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,95 once and liked it 14 people.