package configuration
creating and applying, 297–298
enabling/disabling configurations, 205
using SSIS BIDS menu to add a configuration, 297–298
Package Configuration Organizer, 209
determining configuration order, 210
environment variables, 208
package configurations, 201–202
configuration benefits, 201–202
configuration types, 202
direct and indirect configuration, 202
environmental variable configuration, 202
parent package variable configuration, 202
registry entry configuration, 202
specifying new XML configuration file location, 202
SQL Server table configuration, 202
understanding XML configuration file, 202
XML configuration, 202
package control flow architecture, 114
package execution options, 221–229
command-line utility, 227–228
DTExec, 222–223
DTExecUI, 222
Execute Package utility, 226–229
extending, 224
SQL Agent, 228–229
SQL Server Agent, 224–226
SQL Server Import and Export Wizard, 221–222
SQL Server Management Studio, 223
starting Server Wizard from BIDS, 221
starting Server Wizard from Management Studio, 221–222
package execution, monitoring, 300–306
adding configuration to ImportCustomers.dtsx package, 302–303
deleting existing package from SSMS, 302
deploying package, 304
executing by using configuration files, 306
executing package, 306
inspecting alternate configuration files, 304–305
Package Installation Wizard, 304
running deployed package, 305
Package Installation Wizard
building SSIS sample project, 289–290
deploying packages, 287, 288
enabling deployment utility, 288–289
monitoring package installation, 304
password options, 293
push deployment and, 294
quick reference, 307
package logging
configuration, 230–231, 234
configuring container and task logging, 232–233
executing package and viewing logs, 232–233
implementing, 230–234
understanding, 229–230
package variables
accessing, 174
PackagePassword property, 291, 292, 307
packages
data flow task, 30
executing partially, 185, 198
executing QuickStartIS.dtsc package, 31
preparation SQL task, 30
reviewing elements, 29–30
reviewing QuickStartODS database tables using SSMS, 31
stop debugging and close package designer, 31
testing, 31
packages, deploying, 294–297, 298–299
DTExec, 298–299
DTExecUI, 298–299
executing file system packages, 296
exporting deployed packages, 296
importing ImportCustomers package, 295
importing to MSDB, 296
managing packages on SSIS server, 295–297
monitoring running packages, 296–297
pull deployment, 295
push deployment, 294
packages, securing, 290–291
packages, using expressions in, 73–75
For Loop container, 74
precedence constraints, 74
system variables, 74
user variables, 74
parallelism, 316
parent package
exploring, 218–219
viewing ParentPackage.dtsx package, 218–219
Parent Package variable configuration, 219–220
creating ParentProductsDestination parent package, 219–220
testing package with new configuraton, 220
parent package variable configuration creating, 234
parent package variable, configuration, 202
parent package variables, 209
ParentPackage.dtsx package, 218–219
ParentProductsDestination parent package, 219–220
partially blocking transformations, 73, 313–314
password protection, 291
Percentage Sampling transformation, 387–388
performance management
data destination management, 321–322
data filters, 320
design considerations, 326–329
dropping/disabling indexes, 321
Flat File Sources, 319
locking modes, 321
loops, 318–319
performance-tuning exercises, 322–323
testing DefaultBufferMaxRows and DefaultBufferSize, 325
using explicit transactions, 321
using SQL Server connection manager, 325
variable scope, 320–321
variables, 320–321
Variables collection, 320
working with buffer properties, 323–324
working with SQL Server destination, 324–325
persisted staging, 371
PipelineExecutionPlan event, 331, 336
Log Events window, 336
PipelineExecutionTree event, 330
placeholders, creating, 123–125
PrdCode, 85
PrdName, 85
Precedence Constraint objects, 5
Precedence constraints
applying, 138
defined, 10
precedence constraints, 132–136, 238
constraint values, 132
PrepLoadDimProd.dtsx package, 264–267
Progress messages, 183–184, 190
Progress tab
providing messages to, 148–152, 173
project
defined, 32
Project Property Pages dialog box, 289
projects
executing, 234
ProtectionLevel, 291, 292, 307
ProtectionLevel property, 291
DontSaveSensitive, 291
EncryptAllWithPassword, 291
EncryptAllWithUserKey, 291
EncryptSensitiveWithPassword, 291
EncryptSensitiveWithUserKey, 291
ServerStorage, 291
providing fast and easy access to data, 347–348
providing messages to Progress tab, 148–152, 173
providing verbose information to Log File, 152–156
pull deployment, 295
push deployment, 294