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 means exporting data into destination. Data Flow Task provides bunches of Destination which helps you to perform the Load part of the ETL.
SSIS Data Flow Sources contains the following sources:
OLE DB Source
ADO.NET Source
ODBC Source
Excel Source
Flat File Source
Raw File Source
XML Source
CDC Source
And Data Flow Destinations consists of the following destinations:
ADO.NET Destination
Data Reader Destination
Excel Destination
Flat File Destination
OLE DB Destination
Raw File Destination
Recordset Destination
SQL Server Compact Destination
SQL Server Destination
In this chapter, all of these sources and destinations will be covered. Two new...
