Just a short blog post today explaining a problem (and solution) I ran into when working at a client recently. Hopefully it is helpful for anyone out there.
I recently got this error message at a client when trying to open an SSIS solution in SSDT.
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100'
The reason could be a badly applied Service Pack or CU for example, but I’m not entirely sure about that (source).
Before starting, make sure you close any open Visual Studio instance.
In a Command Prompt go to the following path (be sure to start the Command Prompt as Administrator):
C:\Program Files\Microsoft SQL Server\120\DTS\Binn\
where 120 is you SQL Server version number.
Reregister the dts.dll by executing the command:
If all goes well you should see the following message pop up:
I found info here.
Happy coding :)