April 28, 2016

Error during setting SQL Maintenance plan wizard setting

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)"

Solution:

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.

I hope this will solve to come out from your troubleshooting.