SQL Server 2012: Staging table entries not showing up in Integration Management

Question

I have inserted the data into staging table

INSERT INTO [MDS].[stg].[Import_Leaf]
           ([ImportType]
           ,[ImportStatus_ID]
           ,[Code]
           ,[TableName])
     VALUES
           (2
           ,0
           ,2
          ,'FPL')

and ran the procedure 

EXEC[stg].[udp_Import_Leaf]
@VersionName = N'VERSION_1',
@LogFlag = 1,
@BatchTag = N'batch1'

after running the procedure am able to see the data in [MDS].[mdm.[tbl_8_36_EN]] table but it is not showing up in  Integration Management

I would greatly appreciate any help I can get on this use. Thanks in advance

                

---

Pavan K

Answer 1

which version are you using?  if you are using 2012, you should make use of the entity bases staging.  You will also need to specifiy a batch tag.  If you are using 2008R2, you will need to specify the entity you are importin gto.

Answer 2

as i mensioned above am using 2012 and entity bases staging only

---

Pavan K

Answer 3

during your insert, insert a batch tag also.

Answer 4

Hi Pavan,

You can also look into the following articles, please see:
Master Data Services: Troubleshoot the Staging Process: http://social.technet.microsoft.com/wiki/contents/articles/2392.master-data-services-troubleshoot-the-staging-process.aspx
Importing Data by Using the Staging Process: http://sqlblog.com/blogs/mds_team/archive/2010/02/10/Importing-Data-by-Using-the-Staging-Process.aspx

Hope this helps.

Regards,
Bin Long

---

Bin Long

TechNet Community Support