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

Source: Microsoft Support

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.

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.

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

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.

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

�

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.