NumKeyColumns property in Merge Join not set correctly (BIML express 2018)

I successfully generated a package with Merge Join component but I am getting below error during execution:
Error: 0xC02020B1 at DFT - Load DSEMPSAL, MGJ - Merge Join [19]: The NumKeyColumns value is not valid. In the MGJ - Merge Join, the value for the NumKeyColumns custom property must be between 1 and 1.

I have only one Key, but in NumKeyColumns, It is automatically setting value as 9. I didn't find any syntax to set this value in BIML script.

Do anyone know how we can set NumKeyColumns value dynamically using BIML script?



  • Hi Bharat,

    Sorry for the delayed response. I have not been able to replicate your issue. In your <JoinKeys> node you only have one key present? Would you be able to help us reproduce this issue by sending us a minimal repro case, either built against a public dataset like AdventureWorks or with accompanying DDL, so that we can replicate everything in our environment? You can mail this to

    Thank you,

    Comment actions Permalink
  • The documentation here is a bit wrong, i got the error using Merge join like here:


    Fixed it by setting SortKeyPosition only in my OleDbSource Column collection, NOT inside MergeJoin tag !

    <OleDbSource Name="Destination" ConnectionName="db" ValidateExternalMetadata="false">
    <VariableInput VariableName="User.DestinationQuery"/>
    <Column SourceColumn="ID"></Column>
    <Column SourceColumn="Description" SortKeyPosition="1"></Column>


    Comment actions Permalink

Please sign in to leave a comment.