SSIS 2012/14: Data Flows and Components

The Data Flow task is a special Control Flow task that moves data from a data source to a data destination, optionally transforming the data in various ways as it moves. It is so important and complex that, unlike any other Control Flow task, the Data Flow task has its own designer in SQL Server Data Tools. This is where you are likely to spend most of your time when developing any non-trivial Integration Services package that moves data rather than just performs other Control Flow tasks. The Data Flow task is the single most important task in a Control Flow and performs the majority of the work in an ETL (Extract, Transform, and Load) process. During this Live Learning event, you'll learn about data flow pipelines, how to get data from a source, transform it along the way, and store it in various data store destinations.

Recorded: 5/22/2014


Don Kiely

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.