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?

0

Comments

1 comment
  • 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 support@varigence.com.

    Thank you,

    0
    Comment actions Permalink

Please sign in to leave a comment.