From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introduction to ETL with SSIS - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Introduction to ETL with SSIS
Now I would like to start the first of several sections on using SQL server integration services to develop an ETL solution to extract transform load. ETL is a very important part of a data warehouse when you first setting up a data warehouse a lot of your work goes into designing and building the table structure that will hold the data. Once that's done, it typically doesn't change very often and therefore there's not a lot of maintenance to be done there. On the other hand, the ETL process often does have some changes and some maintenance that needs to be done. ETL is often importing data from an external entity, in other words data we have a little or no control over. Now when something peculiar happens to that data, our ETL process has to react to that. So the ETL process is often changed after the initial deployment. A lot of the day-to-day work of the data warehouse administrator does involve ETL. In order to develop our ETL process, we are going to use integration services. We…
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.