Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

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 Product Categories.xlsx.

1. Go to the MDS WebUI, and then to System Administration.
2. 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.)
3. Create a new SSIS project and name it Entity Based Staging.
4. Create a variable ...