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
.
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 named
BatchTag
ofString
type in the package scope.Add an expression task and name it
Set Batch Tag
.Enter the following expression in the expression task:
@[User::BatchTag] ="Product Category_"+ (DT_WSTR, 4) DATEPART("yy", GETDATE() )+ RIGHT...