In SQL Server 2005 or 2008, the DTS designer application cannot be started on a Windows Vista-based computer or on a Windows Server 2008-based computer

Article translations Article translations
Article ID: 962874 - View products that this article applies to.
Expand all | Collapse all
Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Symptom



Using the legacy DTS Designer that ships as part of the SQL Server 2005 Feature Pack may fail on Windows Vista and Windows 2008 operating systems.   You may receive an error similar to the following:

 

Microsoft Visual Studio:

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

 

You may see a blank DTS Designer window after the error is shown.

Cause



The cause of this problem is a technology called DEP - Data Execution Prevention.

Resolution



There is a fix as part of the SQL 2005 SP3 feature pack download for this problem.

 

To resolve this issue, follow these steps:

1.        Visit the following Microsoft Web site:  http://www.microsoft.com/downloads/details.aspx?FamilyID=536FD7D5-013F-49BC-9FC7-77DEDE4BB075&displaylang=en

2.       Locate the section:  Microsoft SQL Server 2000 DTS Designer Components

3.       Download and run the package to install the tool.

 

This download is required and used by both SQL Server 2005 and 2008 to edit legacy DTS 2000 packages on Windows Server 2008 and Windows Vista.

More Information



How to: Install Support for Data Transformation Services Packages

http://msdn.microsoft.com/en-us/library/ms143755.aspx

 

SQL 2005 Feature Pack Download

http://www.microsoft.com/downloads/details.aspx?FamilyID=536FD7D5-013F-49BC-9FC7-77DEDE4BB075&displaylang=en

 

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Properties

Article ID: 962874 - Last Review: January 14, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Windows Vista Business
  • Windows Vista Ultimate
  • Windows Vista Enterprise
  • Windows Server 2008 Datacenter
  • Windows Server 2008 Enterprise
  • Windows Server 2008 Standard
Keywords: 
kbnomt kbrapidpub KB962874

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com