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
760 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

679 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