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

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."
vbnetcoderAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Brian CroweConnect With a Mentor Database AdministratorCommented:
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
 
vbnetcoderAuthor Commented:
ty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.