Solved

Merge Joiner: "Both inputs of the transformation must contain at least one sorted column, and those columns must have matching metadata."

Posted on 2016-08-22
2
529 Views
Last Modified: 2016-08-22
When i click on my merge join transformation i get the following error:

"Both inputs of the transformation must contain at leasfdgfdt one sorted column, and those columns must have matching metadata."
0
Comment
Question by:vbnetcoder
2 Comments
 
LVL 34

Accepted Solution

by:
Brian Crowe earned 500 total points
ID: 41765920
Just as it says you must sort the inputs before you can merge them.  You can either add Sort transforms after each import or you can sort the input if possible.

http://www.ssistalk.com/2009/09/17/ssis-avoiding-the-sort-components/
0
 

Author Closing Comment

by:vbnetcoder
ID: 41765952
ty
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Jquery in SSIS 5 38
Calling a stored procedure in SSIS for each record 2 65
SSIS Excel Export 8 34
get the results from a fuction is ssis 5 21
Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft :   M…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

778 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