R

Raw File destination, 12, 89

Raw File source, 12, 84

raw files, for staging data, 305

RDBMS, reducing reliance on, 348

read-only variables, 219

ReadOnlyVariables option, Script task, 60, 216, 219–220

read-write variables, 219

ReadWriteVariables option, Script task, 60, 216, 219–220

Really Simple Syndication (RSS) file

importing, 272–278

producing Reporting Services report from, 524–532

Recordset destination, 12, 89

red arrows for precedence constraints, 391

red circle for breakpoints, 409–410

RegisterEvents method, 422

RegisterLogEntries method, 422

Registry Entry option, package configuration, 509

regular expressions, 232

ReinitializeMetaData method, 420, 438–439, 446, 458

ReleaseConnections method, 425

reliability

definition of, 279

error outputs and, 301–304

restarting packages for

checkpoints for, 280–290, 411–412

reasons for, 279–280

transactions for

checkpoints and, 285–288, 289

DTC (Distributed Transaction Coordinator) transactions, 293–299

in Import and Export Wizard, 21

native transactions, 293, 299–300

for script container, getting, 219

for tasks, 44

types of, 293

RemotePath option, FTP task, 54

RemoveFolderFromDtsServer method, Application object, 494

RemoveFolderFromSqlServer method, Application object, 494

RemoveFromDtsServer method, Application object, 493

RemoveFromSqlServer method, Application object, 493

RenameFolderOnDtsServer method, Application object, 494

RenameFolderOnSqlServer method, Application object, 494

Reporting Services, producing report from RSS, 524–532

reports, MSF Agile, 572

RequireFullFileName option, Execute Process task, 51

restarting Data Flow, 305–307, 359

restarting packages

checkpoints for, 280–290, 411–412

reasons for, 279–280

ResultSet option, Execute SQL task, 44–45, 145

roles, assigning to packages, 495

Row Count transformation

for debugging, 235

definition of, 14, 107, 160–161

example using, 161–162

as streaming, non-blocking transformation, 319

Row Number transformation, 308

Row Sampling transformation

as blocking transformation, 322

configuring, 105–106

definition of, 14, 105

row-based transformations

definition of, 320–321

when to use, 363–364

RowDelimiter option, Bulk Insert task, 46

Rows Per Batch option, OLE DB destination, 88

Rows Read counter, Performance Monitor, 367, 368

Rows Written counter, Performance Monitor, 367, 368

RSS (Really Simple Syndication) file

importing, 272–278

producing Reporting Services report from, 524–532

Running Packages folder, 386

RunningPackage method, Application object, 495

RunningPackages method, Application object, 495

runtime components, pipeline

Cleanup method, 424

debugging, 463–466

definition of, 423

DescribeRedirectedErrorCode method, 425

PostExecute method, 424

PreExecute method, 424

PrepareForExecute method, 423

PrimeOutput method, 424

ProcessInput method, 424

runtime engine, 3, 5

runtime mode, BIDS, 32

Runtime namespace, 492