SSIS 2012 Tutorial Vidoes – 2 : Introduction to Control Flow Tasks & Execute SQL Task

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

  • 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
  • Samples
  • Consideration
  • Parameter Marker and Names

view full video here:

All published SQL Server 2012 Integration Services videos can be found here:

Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
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 12 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, Power BI Summit, and Data Insight Summit.
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:

Leave a Reply