Semi-blocking Transformations in SQL Server Integration Services SSIS
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Tue, 03 Jun 2014 06:00:00 UT
Indexed on
2014/06/08
3:34 UTC
Read the original article
Hit count: 432
Filed under:
In a SSIS data flow, there are multiple types of transformations. On one hand you have synchronous and asynchronous transformations, but on the other hand you have non-blocking, semi-blocking and fully-blocking components. In this tip, Koen Verbeeck takes a closer look on the performance impact of semi-blocking transformations in SSIS.
<--- DBA Team 3 (DBA Bundle) -->  | Can 41,000 DBAs really be wrong? Join 41,000 other DBAs who are following the new series from the DBA Team: the 5 Worst Days in a DBA’s Life. Part 3, As Corrupt As It Gets, is out now – read it here. |
© SQL Server Central or respective owner
