SQL Server 2008 R2作业中无法新建与修改步骤的问题

在使用SQL Server 2008 R2时遇到这样一个问题,在SQL Server Agent >> Jobs中新建与修改步骤时出现下面的错误:

 TITLE: Microsoft SQL Server Management Studio

------------------------------

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

------------------------------

ADDITIONAL INFORMATION:

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

解决方法:

  在命令行中运行下面的命令:

c:\windows\system32\regsvr32 "c:\Program Files\Microsoft SQL Server\100\DTS\Binn\dts.dll"

c:\windows\syswow64\regsvr32 "c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll" 

  然后重新打开Microsoft SQL Server Management Studio。

  注:在使用过程中有时还会出现上述错误,解决方法是重新打开Management Studio。

参考文文章:

  SSMS : Can no longer create or edit job steps 

原文地址:https://www.cnblogs.com/dudu/p/1811766.html