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 ADDITIONA开发者_高级运维L 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.
精彩评论