I have a huge involved query - with lots of temp tables ect. At the end I do a Select * from temptable and it displays data.
This query work in SSMS and when I paste it into a OLE Source - it returns the proper rows when I do a preview.
But, when I place it pointing to a destination - database - flat file it returns nothing. Any thoughts?