Time for action – entity-based staging
In this example, we will import sample data rows into the Product Category entity with the entity-based staging method. We will import data into a staging table first, then we will run the batch to transfer records into an entity. We will import the product categories from an existing Excel file named
- Go to the MDS WebUI, and then to System Administration.
- Go to Manage Entities, and then the Product Category entity. You will see the name of the staging table for this entity is Product_Category. This means that the staging table name is
stg.Product_Category_Leaf(you can check if this table exists by going to SSMS.)
- Create a new SSIS project and name it
Entity Based Staging.
- Create a variable ...