O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Asynchronous Script Component

As we discussed in previous chapters, Data Flow transformations are categorized into two categories based on their synchronization behavior: Synchronous and Asynchronous.

Synchronous Transformations process each input row, generate an output row at the same time, and then go to the next row. Asynchronous transformations stack incoming data and generate output based on some input records. An example of synchronous transformation is a Derived column, and an example of asynchronous transformation is Sort, because all rows have to be accumulated in order to sort them.

It's obvious that synchronous transformations are much better in terms of performance as compared to asynchronous transformations, but there are some ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required