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
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.