O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Data Flow Task Part 1—Extract and Load

by Reza Rad and Pedro Perfeito

In this chapter, we will cover:

  • Working with database connections in Data Flow
  • Working with flat files in Data Flow
  • Passing data between packages—Raw Source and Destination
  • Importing XML data with XML Source
  • Loading data into memory—Recordset Destination
  • Extracting and loading Excel data
  • Change Data Capture

Introduction

Extract and Load are two main parts of an ETL (Extract, Transform, and Load). In this chapter, we will cover Extract and Load. Transform will be covered in the next two chapters.

SSIS Data Flow Task provides all the three parts of an ETL. Extract means fetching data from sources. Data Flow Task has some sources which are responsible for extracting data. Load ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required