In ssis I'm using a data flow task, with an OLE DB Source and an OLE DB Destination component. In my source component I'm using the SQL Command data access mode.
When I paste my query into the command text window and click preview I see the error No column information was returned by the SQL command.
Other threads I've seen seem to indicate that this is possible, so I'm wondering if something in my configuration is incorrect. All fields have names, and I can execute other queries against this data source. Is there something I'm overlooking here?
For clarification purposes, my query basically looks like this:
WITH CTE(column1,column2) AS ( SELECT field1 --window function ,field2 FROM table1 ) SELECT column1 ,column2 FROM CTE WHERE condition1 is true