P

Package Explorer, using with Integration Services Designer, 211

package management utilities, using with Integration Services, 212–214

Package Management utility, using with Integration Services, 213

Package Migration Wizard, features of, 213

PackageId system variable, purpose in Integration Services, 195

PackageName system variable, purpose in Integration Services, 195

packages. See also DTS (Data Transformation Services); Integration Services

building, executing, and saving, 197

checkpoint and restart support for, 194

and complex flow control, 196–197

deploying, 211–212

digital signing of, 197–198

DTS-variable support for, 194–196

features of, 192–193

logging operation of, 194

role in Integration Services, 192

running in Integration Services, 210

setting run-time properties of, 193–194

using DTS data adapters with, 198

using system variables with, 195–196

using tasks with, 198–199

PageProductsTable subrouting, using ADO.NET paging function with, 101–102

paging, ADO.NET’s support for, 101–102

=@Param value, relationship to Query Builder, 178

parameterized queries, building with Query Builder, 178

Parse method, using with UDTs, 84

Parse UDT method, description of, 81

password policies

enforcing, 20

location of, 20

PercentComplete system variable, purpose in Integration Services, 195

performance tools

Database Tuning Advisor, 42–44

overview of, 41

Query Editor, 41–42

period (.) symbol, using with UDT members, 84

permissions control, increased granularity of, 19–20. See also Trace permission feature of Profiler

Person.ContactType table, creating extended triggers on, 80

PIVOT and UNPIVOT relational operators, T-SQL support for, 92–93

pods, relationship to NUMA architecture, 6

primary XML indexes, creating, 150

proactive caching, relationship to UDM, 220

Profiler

enhancements in, 44–45

using with Analysis Services, 233–234

Progress* system variables, purpose in Integration Services, 196

project mode in Integration Services, support for, 197

projects

creating in Integration Services, 206

support for, 70–71

Propagate system variable, purpose in Integration Services, 196

Properties window

in Business Intelligence Development Studio, 37

in Report Designer, 167

in SQL Server Management Studio, 32

protocols, using with SQL Server Service Broker, 130–131

Provider Factory, ADO.NET support for, 103–104

Providers section of ADF, description of, 116