Hi,

How do I create my own component that joins (actually it does a lot more, so
it's not a solution to use the existing merge join transform) two huge sorted
input streams without having to cache up too many rows internally in the
component?

To be more specific: What I wonder about is how to ensure that I read the
two input stream in the same pace. After reading some doc, it's not clear to
me how I can control this. It look like the data is pushed to the transform
component rather than pulled into the component. Is it e.g. possible to have
the two inputs to the component in different threads and pausing the thread
that is ahead of the other thread?

Thanks in advance,
Sturle

Have a look at this article by a guy doing the same thing.


http://www.sqlbi.eu/Home/tabid/36/ct...0/Default.aspx


Allan



"Sturle" <Sturle (AT) discussions (DOT) microsoft.com> wrote