B

backpressure, 365

backup and recovery

Package Store location affecting, 287

snapshots used for, 229

banding, data, 99

BI (business intelligence), 1

BIDS (Business Intelligence Development Studio)

connection manager, creating, 7

containers, creating, 19–20

Control Flow tab, 8, 15–17

cube designer in, 194–195

Data Flow tab, 8–15

dimension editor in, 193

Migration Wizard, launching, 341

not supported on Itanium 64-bit machines, 306

package

creating, 7

executing, 17–18

password for, setting, 299

PackageID, generating, 261

source control integration using, 255–259

user-defined variables, creating, 22–24

BizTalk, 2

BLOBTempStoragePath property, 370

blocking transformations, 363, 365

books

The Complete Guide to Dimension Modeling (Kimball, Ross), 92

Microsoft Data Warehouse Toolkit (Wiley), 102

Professional SQL Server 2005 Integration Services (Wiley), 7, 21

Buffer Memory counter, 308

buffer spooling, 357

buffers

performance counters for, 308–309

pipelines managed using, 363

tuning, 370–371

Buffers In Use counter, 308

Buffers Spooled counter, 308–309

BufferTempStoragePath property, 370

Bulk Insert Task

location where executed, 377

migrating to SSIS, 339

business intelligence (BI), 1

Business Intelligence Development Studio. See BIDS

business key (candidate key) of dimension table, 95, 144