I have a fairly complex query that has several table variables and only returns one result set at the end. When I try to use an OLE Source the preview displays correctly, but when I try to assign the columns it says that no colimns were returned.
I have tried several formatting changes and adding begind and ends to group the output select statement differently, but nothing seems to work.
The strange thing is that is I use an ADO.net source the columns are returned and everything works as expected.
The query although in parts (to populate the table variables) is not that complex. It runs faster with the variables compared to derived tables or sub-queries. It begins returning data in about 6 seconds, but I don't think the process that gets the
columns waits long enough to receive the metadata. At least that is my guess as to the issue. Is there a way to increase the time SSIS allows for the DB to return metadata? Or am I on the wrong track?
I am using SSIS 2008 and a SQL 2008 server
View Complete Post