This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/
This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/02/12/ssis-lookup-transformation-is-case-sensitive.aspx
Synchronous components don't have to output all the rows it gets. You can use the redirect method to conditionally out rows to different outputs as the multicast and conditional split do.
Simon,
You are right, of course.
I thought it would be clear that my blog is about normal input / output and not about redirected output.
Thanks anyways for your post; it might be useful for those that are confused.
Jorg
Pingback from Business Intelligence Blog » Blog Archiv » SSIS semi-blocking transformation f??r Distinct
Replace the multiple "Lookup Error Output" Derived Columns and Union All's with a single Derived Column and get a performance boost...
Jorg's just written a great post on lookup performance in SSIS sqlblogcasts.com/.../jorg
Replace the multiple "Lookup Error Output" Derived Columns and Union All's with a single Derived
Pingback from Blocking components | Myfeedbackonli