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

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
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:



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
New Comments to this post are disabled

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