I try to export data to a flat file from OLE DB source. Here is what I do under OLE DB source editor. In SQL command Text:
declare @t table (customerid varchar(100),[enrollment_Date] varchar(100)) insert into @t exec master.dbo.my_stored_procedure select * from @t
In the preview, I can see data but when I execute it, I get empty text file. Do you know why?