object-oriented programming (OOP), 259
ODBC Providers for Oracle, 328
OLE DB destination, optimizing, 372–375
OLE DB Providers
for DB2, 331–332
for Oracle, 327, 328
for VSAM, 332
OLE DB source adapter
parameterized source queries, 70–71
using, 60–61
OnError event, 225–226
OnInformation event, 226
OnPostExecute event, 355
OnPreExecute event, 355
OnVariableValueChanged event, 24
OnWarning event, 225
OOP (object-oriented programming), 259
optimizing SSIS.
See also scalability
data flow properties for, 369–371
destination optimization, 371–376
performance
database growth affecting, 371
of logging, 368
memory utilization, 357–360
partition tables affecting, 372
SQL operations compared to Data Flow Tasks, 360–362
SSIS Service status, checking, 354
task duration, checking, 354
of transactions, 368–369
of writing data to Oracle, 330–331
pipeline optimization, 365–369
Oracle destination, by Persistent Systems, 330–331
Oracle sources
code page warnings from, 328
Oracle client network components for, 326
parameterized queries with, 328–330
providers for, 327–328
reading from, 327–330
writing to, 330–331