In SQL Server 2008\R2 we may come cross this error. The user may not able to edit or create new steps due to the below error :
“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)..”
The above error can be solved by executing below command in Command Prompt:
C:\Windows\System32>regsvr32 “c:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTS.dll”
“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)..”
The above error can be solved by executing below command in Command Prompt:
C:\Windows\System32>regsvr32 “c:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTS.dll”
I registered the .dll still my package was not saving and the
ReplyDelete"Error creating package Failed to save package file with error 0x8002801D "Library not registered."
was coming so I solved the error by re-registering msxml6.dll and msxml3.dll
"regsvr32 %windir%\system32\msxml6.dll
regsvr32 %windir%\system32\msxml3.dll"