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