SQL Server 2005 使用Data Flow Task时出错
点击编辑Data Flow Task时总包错:
TITLE: Microsoft Visual Studio
------------------------------
The task with the name "Data Flow Task " and the creation name "DTS.Pipeline.1 " is not registered for use on this computer.
Contact Information:
Data Flow Task
------------------------------
BUTTONS:
OK
------------------------------
重装也不行。什么原因?
------解决方案--------------------关注,学习
------解决方案--------------------首先不是试用版吧?
------解决方案--------------------应该是权限问题
将你的\Program Files\Microsoft SQL Server\90\DTS\Binn 文件目录授权访问:
加入到SQLServer2005DTSUser$[MACHINE_NAME]组
------解决方案--------------------并赋予 "Read & Execute ", "List Folder Contents " and "Read " 的权限
------解决方案--------------------sql server 2005 sp1安装了吗?