Synchronous and Asynchronous behaviour in SSIS

Most of us have heard the terms ‘Synchronous’ and ‘Asynchronous’ in SSIS but have always been confused between the two. Let’s brush up the concepts.

All the data flow components can be categorized as synchronous and asynchronous. Below table will list out the clear differences between the two:

Synchronous

Asynchronous

  1. The number of rows input to the synchronous components is equal to the number of rows output from synchronous components
  2. Components use the same buffer
  3. All destination components are synchronous
  4. Non-blocking transformations are synchronized
  1. The number of records output from Asynchronous components can be less\ more than the number of records input to the components
  2. Components use different buffer
  3. All source components are asynchronous
  4. Partial\ Full blocking transformations are asynchronous in nature

*If anyone does not have idea about non-blocking\ partial blocking\ full blocking transformations then don’t worry, just keep following my blog. Post comments if you have any queries\ like my blog.

Hope you have a good time from now.

Enjoy guys!!

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