From the course: Implementing a Data Warehouse SQL Server 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understand data flow - SQL Server Tutorial
From the course: Implementing a Data Warehouse SQL Server 2019
Understand data flow
- [Instructor] The SQL Server Integration Services Data Flow task provides the three main components of an ETL process. The first component is the data source. With this component you'll define where the original data is located and how to access it. SSIS supports connections to a wide variety of data storage platforms. Everything from simple Excel spreadsheets to flat files like XML or CSV, or other databases such as Access, Oracle or most SQL Server instances and more. You can even connect to big data providers such as a Hadoop Distributed File System. The data sources connection manager stores all the information needed to retrieve data from these locations, including the network path to the resource, any logging credentials that would be needed to securely access them and the names of specific tables and attribute columns to pull. Once SSIS has successfully connected to a data source, a Data Flow task can pass that…
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.