Hi folks,
I have a query containing table variables for an Ole Db source. The designer correctly deduced the columns from the query and when I hit the Preview button, it shows the data correctly. But when I execute the task, no rows are returned. Am i missing something? Here's a sample query containing the table variable:
declare @mytable table
(
col1 int,
col2 varchar(20)
)
insert @mytable values (1, 'one')
insert @mytable values (2, 'two')
insert @mytable values (3, 'three')
select * from @mytable
Regards,