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
- SSIS Package
- Package Components
- Control Flow Overview
- Control Flow Tasks Categorized
- Variables Overview
- Connection Managers Overview
view full video here:
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
- Parameter Marker and Names
view full video here:
All published SQL Server 2012 Integration Services videos can be found here:
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
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.