none
Loading stage table in Master Data Services 2014 RRS feed

  • Question

  • I am working on entity based staging tables in Master Data Services 2014 and able to import data into the staging tables using SSIS Package.
    Used the Import Type - 2 for this.

    now i need to update one of the columns in the staging table.

    I am able to update the stage table in the database,but the Column in the entity is not updated.
    The entity doent get updated. Only the values from the initial load are available.

    Anyone had this type of issue with MDS?

    Thanks

    Friday, December 18, 2015 5:42 AM

Answers

All replies

  • When you update your value are you resetting the "ImportStatus_ID" back to 0 ? This tells the loading process that the row is ready to be staged.

    Can you also see if you see nay error reported for the row?

    Also do use Web UI to start the loading or call stored procedure to start the loading process?

    You can refer : https://msdn.microsoft.com/en-US/library/ff486990.aspx to know if there are any error reported for the row.


    -Nithesh Shetty Software Engineer, C & E -> IMML -> MDS, Microsoft.

    Tuesday, January 5, 2016 3:34 AM
    Moderator
  • Hi Prath,

    Have you tried the suggestion? Please provide us more information if the issue persists, so that we can make further analysis.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, January 11, 2016 2:20 AM
    Moderator