In SSIS data flow, there are three types of data transformation:  non-blocking, semi-blocking and fully-blocking and all data flow components are categorized to be synchronous vs asynchronous. We need to understand their properties and how to organize them appropriately.

Synchronous components: simply, number of records IN = number of records OUT in buffer cache.

Asynchronous components: number of records IN <> number of records OUT. On the other hand, the result output of a asynchronous component uses a new buffer. It’s impossible to reuse the input buffer because an asynchronous component can  have more or less output then input records.

Generally, synchronous components reuse buffers so they are faster than asynchronous components because they need new buffers. Let see the below table to understand the basically differences

All data-flow components categorized


In next articles, I will explain more detail and provide examples for each type transformations.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s