oData for SSIS

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.

SSIS Unable to cast COM object of type

Issue in SSIS: Unable to cast COM object of type

To fix the problem do the following:

  1. Open the command prompt (run it as administrator)
  2. Navigate to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
  3. Run C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll