Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uma2049
Starting Member
2 Posts |
 Posted - 2010-10-04 : 08:15:42
|
| Hi All I am new in sql server please tell me the Difference between merge Transformation and merge join Transformation in SSIS . RegardsUma Mahesh |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-04 : 09:02:40
|
| It's the same difference what UNION & JOIN clauses has in SQL.Merge Transformation=Union in SQLMerge join Transformation=Join in SQLPBUH |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-04 : 09:39:52
|
quote:
Originally posted by Sachin.Nand
It's the same difference what UNION & JOIN clauses has in SQL.Merge Transformation=Union in SQLMerge join Transformation=Join in SQLPBUH
not exactly =there are a few differences like Merge transformation can accept only two inputs whereas Union all can take more than two inputs. Also,data has to be sorted before using the Merge Transformation whereas Union all doesn't have that prerequisite------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
uma2049
Starting Member
2 Posts |
Posted - 2010-10-05 : 12:53:15
|
| Hi PBUHThanks for your reply but I want only merge transformation and merge join transformation difference in SSISRegardsUma MaheshUma mahesh |
|
|
|
|
|
|
Difference