O

OLE DB Command transformation

configuring, 163

definition of, 13, 105, 162–163

example using, 163–165

optimizing, 363–364

as row-based, non-blocking transformation, 320

OLE DB destination

configuring, 88–89

definition of, 12, 88

when to use, 246

OLE DB source

configuring, 80–83

definition of, 12, 80

OLTP (On-Line Transaction Processing) system, 190

OnError event, 40, 399

OnExecStatusChanged event, 40, 399

OnInformation event, 40, 399

OnInputPathAttached method, 423

On-Line Transaction Processing (OLTP) system, 190

OnOutputPathAttached method, 423

OnPostExecute event, 40, 399

OnPostValidate event, 40, 399

OnPreExecute event, 40, 399

OnPreValidate event, 40, 399

OnProgress event, 40, 399.

OnQueryCancel event, 40, 399

OnTaskFailed event, 40, 399

OnVariableValueChanged event, 40, 399

OnWarning event, 40, 399

Operation option

Aggregate transformation, 91

File System task, 53

FTP task, 54

OperationType option, XML task, 68–69

Oracle database

client setup for, 259

importing from, 259–261

version of driver for, 261

Output window, 32

OutputType option, WMI Data Reader task, 66, 513

OverwriteDestination option

File System task, 53

WMI Data Reader task, 66, 513

OverwriteFileAtDestination option, FTP task, 54