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):

Asked by Tomasz Wieczorkowski
(362 rep)
Jul 18, 2017, 01:57 PM
Last activity: Oct 14, 2017, 10:34 AM
Last activity: Oct 14, 2017, 10:34 AM