We are doing some work with SSIS. We are working with other folks who use SSRS but are not using it ourselves & don't have opinions.

SSIS has a *lot* of options and I can't claim to know them all. I would consider these options

1) Use a script component in SSIS to access the data as you said (as here: http://www.sqlservercentral.com/Forums/Topic384287-148-1.aspx )

2) Write a script component to use the standard LabKey API. This will require some programming to wrap the LK API with .NET. Slightly bigger, extend SSIS with custom object type that can access LabKey via the API.

3) It would be great to have a Connection implementation that accesses the API. We've got an experimental JDBC driver that needs work. It could be wrapped with a bridge to link in to SSIS. Alternately a new one could be written.