<div>
By inputs, you mean rows? &nbsp;How do you define &quot;same&quot; here? &nbsp;The value of the sorted key?
</div>


By inputs, you mean rows?  How do you define "same" here?  The value of the sorted key?

<div>
I think I found the reason. &nbsp;The package is paused due to a mistake in a later component. &nbsp;Therefore the Merge is still in the process.
</div>


I think I found the reason.  The package is paused due to a mistake in a later component.  Therefore the Merge is still in the process.

<div>
<div class="content wysiwyg-content">
In SSIS, after Merge transformation, why the total rows returned are less than the two inputs combined? &nbsp;Thanks.
</div>
</div>


In SSIS, after Merge transformation, why the total rows returned are less than the two inputs combined?  Thanks.

In SSIS, after Merge transformation, why the total rows returned are less than the two inputs combined?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.