The solution for the error:

TITLE: Microsoft Visual Studio

------------------------------

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

------------------------------

BUTTONS:

OK

------------------------------

The reason why you are getting this error is that the data types of the merging columns are different. Set both of them the same type by setting the data-type property in the Advanced Editor