| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Step 4: Add a Data Flow task to the package |
Lesson 1-4: Add a Data Flow task to the package |
chugugrace |
chugu |
01/03/2019 |
sql |
integration-services |
tutorial |
[!INCLUDEsqlserver-ssis]
After you've created the connection managers for the source and destination data, you add a Data Flow task to your package. The Data Flow task defines the data flow engine that moves data between sources and destinations, and provides the functionality for transforming, cleaning, and modifying data as it is moved. The Data Flow task is where most of the work of an extract, transform, and load (ETL) process occurs.
Note
[!INCLUDEssNoVersion] [!INCLUDEssISnoversion] separates data flow from control flow.
-
Select the Control Flow tab.
-
In the SSIS Toolbox pane, expand Favorites, and drag a Data Flow Task onto the design surface of the Control Flow tab.
[!NOTE]
If the SSIS Toolbox isn't available, select the SSIS menu, and then select SSIS Toolbox to display it. -
On the Control Flow design surface, right-click the new Data Flow Task, select Rename, and change the name to Extract Sample Currency Data.
Provide unique names for all components that you add to a design surface. For ease of use and maintainability, the names should describe the function of each component. Following these naming guidelines allows your [!INCLUDEssISnoversion] packages to be self-documenting. Another way to document your packages is by using annotations. For more information about annotations, see Use annotations in packages.
-
Right-click the Data Flow task, select Properties, and in the Properties window, verify that the LocaleID property is set to English (United States).