Expert SQL Server 2005 Integration Services (Programmer to Programmer)

ragged hierarchy, 126

Raw File destination, 321–322

Raw File source, 323–325

raw file source adapter, 63

raw files

breaking up extract files using, 246–251, 316–323

configuring, 248–249

consuming, 323–325

definition of, 245

uses of, 245–246

Reader Role, 297–298

ReadOnlyVariables property, Script Tasks, 24

ReadWriteVariables property, Script Tasks, 24

reliability of packages

auditing for, 226–229

checkpoint files for, 238–242, 245

event handling for, 225–233, 241–242

logging for, 233–237

raw files for, 245–251

snapshots for, 229–233

transactions for, 242–245

WMI integration for, 251–254

replicating data (data integration), 6

reporting on logging, 237

resources. See books

Restating History (Change Type 1)

definition of, 102, 103

implications on SSAS attributes, 222–223

reusability

reusable packages, 259–261

Script Tasks used for, 22

Rijndael encryption algorithm, 40–44

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

Row Count transform, auditing rows to be written, 13

row transformations, 363

row-based operations, 366

row-by-row operations, 366

rows, creating from columns, 311–315

Rows per batch option, OLE DB destination, 375

Rows Read counter, 308

Rows Written counter, 308

RunInOptimizedMode property, 370