udpStagingSweep Stored Procedure, commonly associated with Master Data Services (MDS) for managing staging data, is not available in SQL Server 2019.

Shah, Syed 0 Reputation points
2025-04-28T09:35:40.0566667+00:00

Hi I am upgrading Master Data Services from 2012 to 2019, It appears that the udpStagingSweep stored procedure, commonly associated with Master Data Services (MDS) for managing staging data, is not available in SQL Server 2019. Over the major version upgrades, Microsoft has made quite a few changes to MDS, and certain stored procedures have either been deprecated, refactored, or replaced by newer processes. I am struggling to find this detail in MS Documentation.

My SSIS Packages workflow previously relied on udpStagingSweep to clean up or process staging data, I tried to search online and Microsoft forums could you please advise me any workaround.

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
564 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.