Failed to create instance from Icassfactory for COM component with CLSID {17BCA6E8-A950-497E-B2F9-AF6AA475916F} because the following error occurred: c001f011. (Microsoft.Server.manageDTS).
In "New Maintenance Plan", error:
Failed to create maintenance plan. Additional information: Failed to create instance from IClassFactory for COM component with CLSID {17bca6e8-a95d-497e-b2f9-af6aa475916f} Because of a later error: c001f011. (Microsoft.SqlServer.ManagedDTS) Failed to create instance from Icassfactory for COM component with CLSID {17bca6e8-a950-497e-b2f9-af6aa475916f}. The following error occurred because: c001f011. (Microsoft.Server.manageDTS)
Find a solution from the Web:
32-bit operating system:
Open run (Command prompt),
One, enter the CD C:\Windows\System32 into the C:\Windows\System32 path
Ii. input regsvr32 "C:\Program files\microsoft SQL Server\100\dts\binn\dts.dll"
64-bit operating system:
Open run (Command prompt),
One, enter the CD c:\windows\syswow64 into the c:\windows\syswow64 path
Ii. input regsvr32 "C:\Program Files (x86) \microsoft SQL Server\100\dts\binn\dts.dll"
( if it fails, run as an administrator.) )
Then restart MSMs. (Microsoft SQL Server Management Studio) If the installation path for SQL Server is modified, be careful to modify the appropriate path in the installation directory
Add SQL Job, new step appears: Failed to create instance from IClassFactory for COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2}