THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

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

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.

Published Sunday, March 11, 2007 10:50 PM by Marco Russo (SQLBI)
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



SQLBI - Marco Russo said:

Almost two months ago I wrote a post about the lack of multi-phase data pump control in Management Studio

May 3, 2007 5:56 PM

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement