Another SQL Server 2005 SSIS error
I posted about an error with SSIS. I’ve gotten past that, but now I’m getting another error:
Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)
I found some information on it, but nothing helpful so far.
What is the cause
I never figured it out. I wound up using the MS VHD for SQL Server 2005, which worked just fine for me. I only needed a temporary test environment, so I didn’t troubleshoot this anymore.
You need to register the DTS.DLL file.
Open the command prompt and browse to the Binn directory -
> CD C:\Program Files\Microsoft SQL Server\90\DTS\Binn
At the prompt, run the command -
> regsvr32.exe dts.dll
If there is another error
“Cannot communicate with the debug host process. The IDtsHost interface is not registered. (Microsoft.DataTransformationServices.VsIntegration)”
then you also need to run the below command at the same prompt -
> dtsdebughost.exe /regserver
Thanks!