O


object-oriented programming (OOP), 259

ODBC Providers for Oracle, 328

OLE DB destination, optimizing, 372375

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, 225226

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, 330331

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



Expert SQL Server 2005 Integration Services
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
ISBN: 0470134119
EAN: 2147483647
Year: 2004
Pages: 111

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net