Issue in SSIS: Unable to cast COM object of type
To fix the problem do the following:
- Open the command prompt (run it as administrator)
- Navigate to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
- Run C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll