O

OLE DB connection manager, adding, 65

OLE DB destinations

enabling Fast Load, 337

OLE DB Source

setting from Named Query, 66

OLE DB Source - Employee Query task, 21

OLE DB Source data adapters, adding

quick reference, 65

OLE DB source data adapters, adding, 43–44

adding localhost.is2005sbs Connection Manager, 44

OnCustomEvent, 176

OnError, 176, 177

OnError event handler, 241

adding Log Error Execute SQL task, 250–251

OnInformation, 176

OnPostEvent event handler

adding Log Finish Execute SQL task, 248–249

OnPostExecute, 176–177

OnPostExecute event handler, 241

OnPreExecute, 176, 177, 178, 179, 184

OnPreExecute event handler, 241

adding Execute SQL task to, 244

creating, 243–244, 285

OnProgress, 176

OnQueryCancel, 176

OnTaskFailed, 176

OnTaskFailed event handler, 241

executable lookup names, 255

preventing from escalating from Lookup Names task, 259

OnVariableValueChanged, 176

OnWarning, 176

OnWarning event handler, 241

Open Database Connectivity (ODBC), 68

operational databases

compared to data warehouses, 342

organizing data into nonvolatile, subject-specific groups, 345

Output window, 196

OutputBuffer, 161–162

OVAL

defined, 437