L

LoadDim Prod package

deleting DimProd, 268

deleting staging tables, 268

DTS service, 274

loading DimProd, 268

loading staging tables, 268

LoadDimProd package, 267–278

loading dimension tables using left outer join, 375–380

adding conditional split to find new customers, 378–379

adding flat file destination, 379–380

adding tables to find new dimension members, 376–377

configuring left outer join merge join task, 377–378

creating new project for dimension table load packages, 375–376

localhost.is2005sbs Connection Manager, 44

Locals window, 182

LockForRead, 123

LockForWrite, 123

locking modes, 321

Log Error Execute SQL task

adding to OnError event handler, 250–251

log events

adding to, 337

Log Files

providing verbose information to, 152–156

Lookup Names, 254

Lookup Names task

event records, 262

preventing from escalating to Foreach Loop container, 259

Lookup transformation, 106–108

LookupGeography Package, 102–103

loops, 318–319