Data flow transformations in SSIS use memory/buffers in different ways. The way transformation uses memory can impact the performance of your package. Transformations memory/Buffer usage are classified into 3 categories: 1.Non Blocking 2.Semi Blocking 3. Full Blocking All the dataflow components can be categorized to be either Synchronous or Asynchronous. Synchronous vs Asynchronous : Synchronous components The output of an synchronous component uses the same buffer as the input. Reusing of the input buffer is possible because the output of an synchronous component always contain exactly the same number of records as the input. … Read more