Chapter 3. Creating SSIS Packages
Exam objectives in this chapter:
Extract and Transform Data
Define connection managers.
Design control flow.
Data movement represents an important part of data management. Data is transported from client applications to the data server to be stored, and transported back from the database to the client to be managed and used. In data warehousing, data movement represents a particularly important element, considering the typical requirements of a data warehouse: the need to import data from one or more operational data stores, the need to cleanse and consolidate the data, and the need to transform data, which allows it to be stored and maintained appropriately in the data warehouse.
Microsoft SQL Server 2012 ...