Titlebook: Pro SQL Server 2012 Integration Services; Francis Rodrigues,Michael Coles,David Dye Book 2012 Francis Rodrigues and Michael Coles and Davi

audiologist

Advanced Control Flow Tasks,rganized in the SSIS Toolbox in configurable groups. We already introduced the Favorites and Common groups as well as one of the containers. This chapter presents the remaining tasks in the Other Tasks group and the remaining containers. These tasks and containers generally perform administrative ta

謊言

Source and Destination Adapters,allows you to encapsulate data movement and transformation as a self-contained task of the .. The data flow moves your data from a source to a destination, like King Solomon’s river moves water from its sources to the sea. This chapter introduces the data flow and discusses data flow source adapters

lavish

進(jìn)入

Variables, Parameters, and Expressions,s no different in this regard. The variables available to SSIS have their own data types that often correlate to SQL Server data types. Parameters are used to pass values between parent and child packages to extend the modularity of an ETL project. And an expression language is provided to allow the

mortuary

CLAY

難聽的聲音

hypnotic

graphy

Heterogeneous Sources and Destinations,llows you to extract from any storage method and load data into just as many data storage systems. The toolset provided by Integration Services truly attempts to achieve the goal outlined by Bill Gates to allow various systems to mesh well together. As discussed in previous chapters, data integrity

OFF

Data Flow Tuning and Optimization,gh raw throughput is important in any ETL process, the “need for speed” must be balanced against other requirements such as resource contention with other processes; correct and consistent results; and solution maintainability, manageability, and robustness.