How can you recognize these three component types, what is their inner working and do they acquire new buffers and/or threads? Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or fully-blocking. Before I explain how you can...