Moving data with data flow

- Alright, now we're gonna take a look…at the concept of moving data on the Data Flow tab.…It's important to understand that there's a Data Flow tab,…which I have highlighted here,…and there's also a Data Flow Task.…Right now I've created this little blank Package…in here it's called NoTasks…and it's just to demonstrate what happens.…If I come over to Control Flow…I've created a Data Flow Task here,…so then if we go over to Data Flow…you'll see I have a Design page open here…and I could add another information, other tasks to it.…

If I go back over to Control Flow…and Delete this task and now go over to Data Flow…it tells me I don't have a Data Flow Task.…So as I say, it's important to understand…there's a difference between a Task and a Flow.…So if I come back over to Control Flow…and add a Task back in.…Just double-click on the Task,…I've now got Data Flow Task.…And go over to Data Flow, there it is.…Back over to Control Flow, add another Data Flow Task,…and I've got these rolling on down like this.…

And if I come back over to Data Flow,…

Resume Transcript Auto-Scroll

Author

Released

2/3/2015

Microsoft SQL Server Integration Services, or SSIS, is an enterprise-level ETL tool: a tool for extracting, transforming, and loading data. Whether you're looking for information in flat files, via FTP, or on the web, SSIS allows you to transform it all into a uniform format for databases. In this course, Ron Davis teaches this mission-critical skill for IT professionals, developers, and data analysts. Ron covers the architecture of SQL Server Integration Services, the platform's tools, basic task scripting, and the variables, parameters, and expressions you can use to customize your ETL packages. Plus, discover how to use containers to group and repeat tasks, how to merge datasets with joins, and how to debug packages, and learn about common design patterns that will increase your efficiency in SSIS.