Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
1,742 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 2000 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/
1
 

Author Closing Comment

by:vbnetcoder
ID: 41765952
ty
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

916 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