It was with great anticipation I installed the SharePoint List Source and Destination BIDS adapters (from CodePlex, http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652).
Unfortunately, the adapters are not working for our MOSS sharepoint instance. We're a DOD (department of defense) site, so the level of security may be higher than normal and may be affecting the adapters.
The error message was lengthy and I couldn't copy it and paste here. I did screen shots and put the complete error message at http://www.christianbahnsen.com/sharepoint_source_error_message.pdf
If I can get this to work I think it would be very useful. I'd played around with KPI Lists, but one cannot create an Indicator directly from SQL Server 2008 (cf. my related thread at http://social.msdn.microsoft.com/Forums/en/sharepointbi/thread/bcc95f65-012e-4b8a-8850-b03fb0f16b0f). I was hoping that these adapters would provide a work-around by populating sharepoint lists that could be the source for KPI Indicators.
As always, thanks in advance for any assistance.
View Complete Post