From the course: SQL Server Integration Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Data flow components

Data flow components - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Data flow components

“

- [Instructor] Like the control flow tasks, data flows use a series of components to describe the sequence of steps that Integration Services packages will move through. But where control flows describe various actions to take, data flows describe the movement of data. The components that you can add to the design service of a data flow diagram include the source of data that you want to pull from. These will use connections to external resources like a SQL Server database, an Excel file, an Oracle database, Hadoop cluster, or any other source with a supported connection manager. Then you can pass that data through one or more transformations. Transformations will modify the data through a variety of components. For instance, you might convert the incoming values into a different data type, or sort them differently from how they're sorted in the data source. You might apply an aggregate function to the data, or filter the records to just include a statistically significant sample of…

Contents