B


back pressure on source extractions, 359

BankBatchDetail table, payment processing database, 606–607

BatchSize option, Bulk Insert task, 46

bcp.exe tool, 46

BIDS (Business Intelligence Development Studio)

definition of, 3, 25

navigation pane, 31

project, creating, 26, 27–28

runtime mode, 32

starting, 25

windows in, 32

BLOB counters, Performance Monitor, 367

BLOB data types

exporting, 100–101, 159–160

importing, 101, 150–157

blocking nature of transformations

blocking transformations

as asynchronous, 326

definition of, 322–324

when to use, 364–366

definition of, 319

non-blocking transformations

definition of, 319–321

as synchronous, 328

semi-blocking transformations

as asynchronous, 326

definition of, 321–322

blue arrows for precedence constraints, 391

Boole, George (An Investigation of the Laws of Thought, on which are founded the Mathematical Theories of Logic and Probabilities), 548

branching code, 565, 584

breakpoints

definition of, 223, 408

setting, 223, 408–410

Breakpoints window, 32

bubbling of events, 406–408

buffer counters, Performance Monitor, 367, 368–369

buffers used by Data Flow

definition of, 317–318

execution trees and, 332–334

optimizing, 361–363

Bulk Insert task

configuring, 46–48

definition of, 5, 46

example using, 48–51

BulkLoadZip.dtsx file, 48

Business Intelligence Development Studio (BIDS)

definition of, 3, 25

navigation pane, 31

project, creating, 26, 27–28

runtime mode, 32

starting, 25

windows in, 32

BypassPrepare option, Execute SQL task, 45

Byte Reversal operation, Character Map transformation, 94



Professional SQL Server 2005 Integration Services
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
Year: 2006
Pages: 182

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net