Non-blocking Transformations


Because some transformations need to work with only individual field values for rows in the pipeline, they can transform the data row by row. A transformation with this requirement can begin to process data as it flows to it and will make processed rows available down the pipeline as they are processed, and data can stream through this transformation. This process is synchronous and does not block the next transformation in the pipeline.

These transformations either manipulate data or create new fields. Compared with most other transformations, they are fast and efficient.

  • Audit

  • Character Map

  • Conditional Split

  • Copy Column

  • Data Conversion

  • Derived Column

  • Multicast

  • Percent Sampling

  • Row Count

  • Script Task

  • Import/Export Column

  • SCD

  • OLE DB Command

Sources

Transformations are not the only components that can be categorized as synchronous or asynchronous. Data sources are a special type of asynchronous component. Each source component automatically creates two buffers: one for the Success output and one for the Error output.




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

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