I tried creating a new SSIS package and when I tried Doping a Data Flow Source (say OLEDB Source). I get the error The Component cannot be added to the Data Flow task. With the following Additional information ADDITIONAL INFORMATION:
Interface not registered (Exception from HRESULT: 0x80040155) (Microsoft.SqlServer.DTSPipelineWrap)
This sounds like an incomplete installation of your development environment.
I noted that there are options "Other Sources" and "Other Destinations" .. i.e. maybe no requirement to even use the "Source Assistant" and "Destination Assistant" dialog options on the SSIS toolbox for the Data Flow.
User contributions licensed under CC BY-SA 3.0