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