I've researched this question on the InterWeb and already found the INNUMERABLE responses that all claim the solution is to "set nocount on". however, that has done absolutely nothing for me.
Plus, my SQL code isn't a stored procedure; it's just SQL code., but it clearly and unambiguously selects columns from a CTE as the last statement.
it runs fine in SSMS, but the data flow task (oledb source), errs out with "ERROR - Error: A rowset based on the SQL command was not returned by the OLE DB provider.".
Are there any other solutions ??