Components not available to add to toolbox

Jan 20, 2016 at 12:05 PM
Hi, just installed SQL 2012 and the adapter msi. When I create a new SSIS package in SQL Server Data Tools(aka BIDS), the components are not there to add. I've tried a server restart, re-installed etc. nothing works. Any Ideas ?
Jan 27, 2016 at 7:06 PM
I am also having this issue. Was there any solution?
Jan 28, 2016 at 8:13 AM
Yes. If you go to the Data Flow tab of the package design, you should see the SharePoint Source and Destination components within the common section of the SSIS toolbox. Just drag and drop them as required. Watch out for the caveats such as NOT mapping your SharePoint Destination ID initially... SharePoint MUST create them. Also remember to create connections for both ends, watching out for URL and list name accuracy. Also, use service accounts to avoid permission issues etc.

hope it all goes well !

Adrian