I wrote a cte against an Oracle database and the query executes without issue when working in Oracle SQL Developer. I need to use ssis to transport the results of that query to a SQL Server database.
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?