locked
MDS 2012: Unable to move Stage data to MDM tables RRS feed

  • Question

  • Hi team,

    I am new into MDM development, finding issue while moving the data from stage table to mdm table in MDS 2012.

    Issue: 

    Development Environment

    I have an SSIS package which is deployed and running through SQL Agent Job for Stage Leaf data to load into MDM tables. It is working fine for the environment.

    DEV Environment MDS 2012 Version: 11.0.5058.0

    mdm.tblSystem details as below ProductVersion 11.0.0.0, SchemaVersion 11.2.0.0

    QA Environment

    Now, the same SSIS package is deployed and configured to run SQL Agent Job with QA connection for Stage Leaf data to load into MDM tables. It does not move the data from Stage Leaf to MDM tables and instead Stage Leaf table gets updated with the ImportStatus_ID=3.

    QA Environment MDS 2012 Version: 11.0.2100.60

    mdm.tblSystem details as below ProductVersion 11.0.0.0, SchemaVersion 11.0.2.1

    Could any one please help regarding the following issue?


    Mitulkumar Brahmbhatt | Please mark the post(s) that answered your question.


    • Edited by Mitul Brahmbhatt Thursday, September 21, 2017 4:13 PM minor change required
    Thursday, September 21, 2017 4:03 PM