Sunday, March 11, 2007 - Posts

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_USER\Software\Microsoft\Microsoft SQL Server\80\DTS\Settings




Cross-posted from SQLBlog! - http://www.sqlblog.com