SSIS development tools compatibility can be difficult to navigate. Here is an excellent article on that:
Microsoft now has oData available as a datasource for SSIS packages. For my version of SSMS, it meant downloading and installing the SQL 2014 feature pack “ODataSourceForSQLServer2014-amd64.msi” file.
This means being able for example to pull in data from F&O or SharePoint, directly into a SSIS package.
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