Enable multi-phase data pump in DTS editor (Management Studio)

If you edit a legacy DTS package with SQL Server Management Studio, you may want to know how we can show the multi-phase data pump operations.

I haven’t found an option to do this with SQL Server Management Studio. However, when you need to do something, you find a way to do that thing…

I found that necessary setting can be controlled through this registry key:

HKEY_CURRENT_USERSoftwareMicrosoftMicrosoft SQL Server80DTSSettings

Our “multi-phase” data pump is controlled by DesignerSettings (REG_DWORD): if set to 1, the edit of multi-phase data pump is enabled in DTS Editor. Very hard to find… I also posted a bug here.

Article written by
Post originally appeared on:  sqlblog.com
 Enclose code in comments with <PRE></PRE> to preserve indentation.