P

package configurations

for dynamic connections, 35–36, 64–65

repository for

creating, 266–269

reading variables from, 269–272

reasons to use, 266

setting variables, 272–274

SSIS Package Configuration option for

creating, 262–263

definition of, 261

managing, 265

multiple, 264–265

package execution strategies

Bulk Insert Task, 377

data flows, 378

destination server package execution, 379–380

distributed server package execution, 381–382

Execute SQL Task, 377

source server package execution, 378–379

stand-alone server package execution, 380–381

storage and execution locations, 376–377

package installation wizard, 275–279

package roles, 297–299

Package Store

definition of, 281

location of

determining, 283

on file system, 287–288

in msdb database, 287–288

SSIS Service for, 281–283

packages (DTS)

administration of, 335–339

editing, 336

importing, 336

running, 336–339

scheduling, 336

packages (SSIS)

administration of

command line utilities for, 299–301

firewall issues regarding, 299

in Management Studio, 288–299

performance counters, 308–309, 357

scheduling packages, 284, 301–305

tasks in, 6–7

availability of, Package Store location affecting, 288

containers for, creating, 19–20

corrupt, handling, 301

creating, 7

deployment of

package installation wizard for, 275–279

Package Store location affecting, 287–288

utility for, creating, 274–275

executing

in BIDS, 17–18

with DTexec.exe utility, 300

with DTExecUI.exe utility, 290–297

with SSIS Service, 282

monitoring execution of

in Management Studio, 288–289

with MsDtsServer service, 282–283

with performance counters, 308–309, 357

precedence constraints for, 15–17

re-encrypting, 300

reliability of

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

reusable, 259–261

scheduling of

with proxy accounts, 303–305

with SQL Server Agent, 301–303

troubleshooting, 303

when using central SSIS server, 284

security for

firewall port settings, 299

package roles for, 297–299

Package Store location affecting, 287, 299

passwords for packages, setting, 299, 301

re-encrypting packages, 300

on separate, central server, 283–284

sharing data sources among, 57

source control integration for, 255–259

stopping with SSIS Service, 282

tasks, configuring, 8–14

team development of, 255–259

templates for, 260–261

parameterized queries with Oracle sources, 328–330

parameterized source queries, 70–71

parent-child dimension tables

definition of, 94

with SCD Wizard, 125–128

partial cache, 366

partially blocking transformations, 363

Partition Processing destination

for processing cubes, 221

for SSAS processing, 197, 207–208

partition tables, performance affected by, 372

partitions (SSAS)

managing (creating, modifying, deleting), 197–198, 217–220

processing dynamically

with AMO, 216–217

with ASCMD executable, 211–214

with Execute DDL Task, 214–216

processing of, 194–195

performance

database growth affecting, 371

of logging, 368

memory utilization, 357–360

partition tables affecting, 372

SQL operations compared to Data Flow Tasks, 360–362

SSIS Service status, checking, 354

task duration, checking, 354

of transactions, 368–369

of writing data to Oracle, 330–331

performance counters, 308–309, 357

Persistent Systems, Oracle destination by, 330–331

pipeline

architecture of, 363–365

definition of, 101

optimization, 365–369

Pivot transformation

for data grain changes, 174

null values handled by, 314

post-data flow process, for inferred member creation, 182

PostExecute event, 225

PostExecute() subroutine, 26

precedence constraints, 15–17

pre-data flow check, for inferred member creation, 182

PreExecute event, 225

process add, for SSAS dimensions, 194

process clear, for SSAS mining structures and models, 196

process data

for SSAS dimensions, 194

for SSAS partitions, 195

process full

for SSAS mining structures and models, 196

for SSAS partitions, 195

process index

for SSAS dimensions, 194

for SSAS partitions, 195

process structure, for SSAS mining structures and models, 196

process threads, 363

process update, for SSAS dimensions, 193

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

profiling data, 48–52

properties.

See also specific properties

for data flow optimization, 369–371

overriding when running packages, 293

property expressions

for dynamic connections, 36

updating connections using, 64–66

proxy accounts, scheduling packages using, 303–305

publications. See books