P

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