The SSIS Runtime object could not be created. Verify that DTS.dll is available and registered. The wizard cannot continue and it will terminate.
Additional information:
Retrieving the COM class factory for component with CLSID {07E0FB35-8193-4F73-BD6E-F689AD1D9112} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). (DTSWizard)
Answer (2)
The error message you encountered relates to an issue with Microsoft SQL Server Integration Services (SSIS). This error happens when the SSIS Runtime object cannot be created due to a problem with the registration of a necessary library file, DTS.dll. Here are the steps you can take to resolve this issue:
Check Platform Compatibility: Ensure you are running on a compatible platform. This error commonly occurs when trying to run 32-bit applications on a 64-bit environment. If you're on a 64-bit system, try using the 32-bit version of SQL Server Data Tools (SSDT).
Register DTS.dll: The error code REGDB_E_CLASSNOTREG suggests that the DLL file may not be properly registered. You can manually register the DTS.dll file using the following command in Command Prompt with administrator privileges:
regsvr32 "<path_to_dts.dll>\DTS.dll"
Replace <path_to_dts.dll> with the actual path of the DTS.dll file on your system.
Reinstall Integration Services: If registering the DLL does not resolve the issue, consider reinstalling Microsoft SQL Server Data Tools and Integration Services to replace any corrupted files that might be causing the problem.
Check Permissions: Ensure you have the necessary permissions to access the required system registry entries and file paths. Administrative rights are usually required to perform installations and program registrations.
Update System: Make sure that your system and all related SQL Server components are updated. Sometimes, missing updates can lead to such incompatibility issues.
By following these steps, you should be able to troubleshoot and resolve the error you are experiencing. If the problem persists, consulting the official Microsoft documentation or reaching out to their support might provide further assistance.
The error with SSIS indicates a problem with the registration of the DTS.dll file. To resolve it, check compatibility, register the DLL, consider reinstating SSIS, verify permissions, and ensure everything is up to date. Following these steps should help troubleshoot the error effectively.
;
