SSIS Dataflow merge join  and sort tranfomation (fully block performance)

Posted on 2012-04-05
Medium Priority
Last Modified: 2012-06-27
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.
Question by:nishant joshi
  • 2
LVL 11

Expert Comment

ID: 37815549

  For sorting incomming rows ,instead Sort Transformation .you can set the sort operation in OLD DB source .
check the below link


if suppose you are doing any join opeartion use Look up ... this is fast in performance wise .

by using the above you can redirect your matching and nonmatching rows like merge join .

if you want more information , pleaae let me know your Scenario.

LVL 14

Accepted Solution

nishant joshi earned 0 total points
ID: 37815730
Thanks for comment.
I want use multiple joins


select * from test t
join xys on xyz. =
join xyz1 on xyz1. = 

Open in new window

i know look up with is fast for less data not for big data.
LVL 14

Author Closing Comment

by:nishant joshi
ID: 38103378
Not get solution

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question