Problem
Getting Error during setting SQL Maintenance plan wizard setting.
"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)"
This type of error comes due to t the unregistered COM in dts.dll which is located in
in command line change directory and path of dll file is C:\Program Files\Microsoft SQL Server\100\DTS\Bin
You can run the following from the command line to resolve this error:
REGSVR32.EXE dts.dll
Then you need to disconnect from management studio and reconnect, it again then set SQL Maintenance plan wizard again it should work.
Getting Error during setting SQL Maintenance plan wizard setting.
"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)"
Solution:
in command line change directory and path of dll file is C:\Program Files\Microsoft SQL Server\100\DTS\Bin
You can run the following from the command line to resolve this error:
REGSVR32.EXE dts.dll
Then you need to disconnect from management studio and reconnect, it again then set SQL Maintenance plan wizard again it should work.
I hope this will solve to come out from your troubleshooting.