SQL Server 2008 Support DTS Design

66 阅读 0 评论 44 点赞

我是靠谱客的博主飞快便当，最近开发中收集的这篇文章主要介绍SQL Server 2008 Support DTS Design，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

默认 SQL Server 2008 R2 的Management Studio不支持查看和修改DTS。

会出现如下错误：

因此需要额外安装一些组件来支持：

1.安装Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC_x64)

如果是32位系统，从这里下载：

http://download.microsoft.com/download/3/1/6/316FADB2-E703-4351-8E9C-E0B36D9D697E/SQLServer2005_BC.msi

2.安装Microsoft SQL Server 2000 DTS Designer Components(SQLServer2005_DTS)

3.网上很多帖子是复制文件，比较麻烦

1. Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%Microsoft SQL Server80ToolsBinn folder to the %ProgramFiles%Microsoft SQL Server100ToolsBinnVSShellCommon7IDE folder.

2. Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%Microsoft SQL Server80ToolsBinnResources1033 folder to the %ProgramFiles%Microsoft SQL Server100ToolsBinnVSShellCommon7IDEResources1033 folder.

但我试过其实有个很简单的办法

修改系统环境变量PATH的值就可以了：

只要保证PATH中的C:Program Files (x86)Microsoft SQL Server80ToolsBinn 路径配置在D:Program FilesMicrosoft SQL Server100ToolsBinn 前就可以了

配置好后，启动SMSS，连接server到Legacy à Data Transformation Services中找

举例，我系统的PATH值为：

%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program Files (x86)IntelOpenCL SDK2.0binx86;C:Program Files (x86)IntelOpenCL SDK2.0binx64;C:Program Files (x86)Microsoft SQL Server80ToolsBinn;D:Program Files (x86)Microsoft SQL Server100ToolsBinn;D:Program FilesMicrosoft SQL Server100ToolsBinn;D:Program FilesMicrosoft SQL Server100DTSBinn;D:Program Files (x86)Microsoft SQL Server100ToolsBinnVSShellCommon7IDE;C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssemblies;D:Program Files (x86)Microsoft SQL Server100DTSBinn;C:Program FilesMicrosoftWeb Platform Installer;C:Program Files (x86)Microsoft ASP.NETASP.NET Web Pagesv1.0;C:Program Files (x86)Windows Kits8.0Windows Performance Toolkit;C:Program FilesMicrosoft SQL Server110ToolsBinn;C:Program FilesTortoiseSVNbin