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

圣人

冒煙

讓你明白

transplantation

Inflated

exceed

Control Flow Basics,In this chapter, we detail the control flow tasks that you are most likely to use on a daily basis. Chapter 6 covers the less frequently used executables. The control flow defines the operations that a package performs, and the order and conditions required to execute them.

corn732

Source and Destination Adapters,tion, 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, destination adapters, and the new Source and Destination Assistants.

冥想后

Data Flow Transformations,na indicated, our ultimate goal is to start with raw data and use it to reach a state of insight. Data flow transformations are the key to moving your raw data along the first half of that journey, turning it into usable information.

lambaste

Scripting,mponent are two tools that give you an extra power boost. With the Script task and script component, you can use .NET code to enhance your SSIS packages and to manipulate and transform your data in ways the stock components can’t.

Endoscope

Events and Error Handling,pacity planning), but a robust ETL system requires that you also focus attention on building in error handling. Although much of your attention will be focused on issues you can anticipate, unforeseen events can cause the biggest heartburn. This chapter covers SSIS events and event handling, as well as error handling and recovery.