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:
And Data Flow Destinations consists of the following destinations:
In this chapter, all of these sources and destinations will be covered. Two new...