Chapter 3. Creating SSIS Packages

Exam objectives in this chapter:

  • Extract and Transform Data

    • Define connection managers.

  • Load Data

    • 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 ...

Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.