Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2011-05-12
Medium Priority
Last Modified: 2012-05-11
In SSIS, after Merge transformation, why the total rows returned are less than the two inputs combined?  Thanks.
Question by:thomaszhwang
  • 3
LVL 39

Assisted Solution

by:Pratima Pharande
Pratima Pharande earned 1000 total points
ID: 35752287
same inputs from both get counted as one row

Author Comment

ID: 35752412
By inputs, you mean rows?  How do you define "same" here?  The value of the sorted key?
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 1000 total points
ID: 35752832
If you use Merge then have some condition to join both tables (Join Type)

Accepted Solution

thomaszhwang earned 0 total points
ID: 35754309
Where can I set the Join Type?  Thanks.

Author Closing Comment

ID: 35783842
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.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

581 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