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
|
- The number of rows input to the synchronous components is equal to the number of rows output from synchronous components
- Components use the same buffer
- All destination components are synchronous
- Non-blocking transformations are synchronized
|
- The number of records output from Asynchronous components can be less\ more than the number of records input to the components
- Components use different buffer
- All source components are asynchronous
- Partial\ Full blocking transformations are asynchronous in nature
|
No comments:
Post a Comment