@OPC

Sorry for the delay in answering. It was running against the OLEDB datasource (SQL server 2005).

I eventually fudged it by creating the SELECT statement as a view in the database and calling that instead, filtering in the WHERE clause for the search conditions.