From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Join today to access over 24,700 courses taught by industry experts.
Implementing data flow - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Implementing data flow
In this section, I'd like to talk about implementing a data flow. I'm going to create a new project and I'm going to name this project the ResellerPackage. I'm going to store mine in the default location. You can put yours wherever you like. Just remember where it is, because we will be coming back to this package again in future exercises. So I am going to take a Data Flow Task and drag it onto the control surface, and then I'll double-click on that Data Flow Task and now we see that my environment has changed a little bit. Across the top we can see I'm on a different tab. No longer on the Control Flow tab. Now I am on the Data Flow tab. And my toolbox has changed. I now have different tools available to me to accomplish different tasks. All of these tasks, focus on extracting, transforming or loading data. Every Data Flow Task is going to need to a source and a destination. In other words, it's a place where pulling data out of and a place where inserting data into. So first, I'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.