Sample Header Ad - 728x90

Verify which MDS.stg table is related to which MDS model for SSIS data load

1 vote
0 answers
69 views
I need to load the data into the MDS staging tables by using SSIS. The problem is that there are many MDS models, and every one of them has its own staging tables, but they are not named properly (by using model_name.stgTable scheme). They just have numbers at the end. Could you tell me how to verify which MDS.stg table is related to which MDS model? Example (staging Status tables for different MDS models): enter image description here
Asked by Tomasz Wieczorkowski (362 rep)
Jul 18, 2017, 01:57 PM
Last activity: Oct 14, 2017, 10:34 AM