SQL Server Agent to create new or edit jobs when the error is as follows
Error message:
Title: Microsoft SQL Server Management Studio
------------------------------
Failed to create instance from IClassFactory for COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} due to the occurrence of
The following error: c001f011. (Microsoft.SqlServer.ManagedDTS)
Workaround:
32-bit operating system:
Open Run as Administrator (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 as Administrator (Command prompt),
One, enter the CD c:\windows\syswow64 into the C:\WINDOWS\SYSWOW64 path
Ii. input regsvr32 "D:\Program Files (x86) \microsoft SQL Server\100\dts\binn\dts.dll"
Note: Replace the directory in step 2 above with your own SQL Server installed directory
Execution appears the following prompt interface indicates successful execution
Turn off msms, reopen msms, edit a job step, and you'll see the problem solved.
SQL Server Agent new or edit job error