Currently working with Dataflow task in ssis having an issue with merge join.
merge join always require sorted property o set true.
then if we want to use multiple merge join then we have use sort tranformation which is fully block so which reduces the performance.
Is there any way to overcome these problem.
Thank in Advance.