Hi Folks,
In previous video of SQL Server 2012 Integration Services tutorial videos I’ll introduced SSIS as an ETL and Data Transfer tool, I’ve talked about Import and Export Wizard and we had a quick look at SSDT.
In this video I talk about the structure of package and control flow tasks and the Execute SQL Task with samples.
Introduction to Control Flow Tasks
Package is the execution core in SSIS, in this video SSIS
Package and its components will be explained, this video contains these
headlines:
- SSIS Package
- Package Components
- Control Flow Overview
- Control Flow Tasks Categorized
- Variables Overview
- Connection Managers Overview
view full video here:
https://radacad.com/ShowVideo.aspx?cpid=10&vid=2
Execute SQL Task
This is a tutorial video about what are usages of Execute SQL
Task and how to use it with parameters and work with output result set.
samples of executing sql statements with or without input parameters and
returning single or multiple rows also included. this video contains:
- Usages of Execute SQL Task
- Samples
- Consideration
- Parameter Marker and Names
view full video here:
https://radacad.com/ShowVideo.aspx?cpid=11&vid=3
All published SQL Server 2012 Integration Services videos can be found here:
https://radacad.com/CoursePlan.aspx?course=1
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.