L

labeling (striping) versions of code, 586–587

lazy-add, 173

Legacy folder, 388

Linguistic Casing operation, Character Map transformation, 94

LoadFromDtsServer method, Application object, 493

LoadFromSqlServer method, Application object, 493

LoadFromSqlServer2 method, Application object, 493

LoadPackage method, Application object, 493

LocalPath option, FTP task, 54

Locals window, 32, 223–224

Lockbox file, payment processing case study

Control Flow for, 616–622

description of, 595, 600–601

processing for, 631–635

processing requirements, 596

validation for, 622–631

Log method, Dts object, 219, 222

log providers

defining events to log, 506–507

definition of, 505

programming, 507–508

types of, 506

logging

for Bulk Insert task, 48

definition of, 16, 412–413

for packages, 412–416

pipeline logging events, 335–339

for Script task, 221

for tasks, 44, 413

LoggingMode property, 44, 415

logins for databases, transferring, 201–203, 204–205

LogProvider object, 507

LogProviders object, 507

Lookup transformation

configuring, 101–102

data correlation by, 348, 349–352

definition of, 13, 101

example using, 132

as row-based, non-blocking transformation, 320

as streaming, non-blocking transformation, 319

looping

For Loop container

configuring, 75

definition of, 10, 74

example using, 75–78

Foreach Loop container

definition of, 10, 78

example using, 78–80, 139–140

types of, 78

Lowercase operation, Character Map transformation, 94

LTRIM function, 131