Setting Up BCS and the Secure Store Service in SharePoint 2010

It’s supposed to be simple to set up an External Content Type with SharePoint Designer. You just create the connection, flick a few settings, and voila, you’ve got external data available in SharePoint. At least every time I’ve seen it demoed, it works really well. The blog posts out there also paint is as a…

Possible Bug in Aggregate Data Sources in DVWPs?

I think I’ve found a bug in using aggregate data sources in DVWPs with SQL Stored Procedures.  I’m trying to use the results of a Stored Procedure combined with the content of a list in SharePoint.  I’ve isolated the issue to the Stored Procedure. The first asp:SqlDataSource statement below is what I want the data…