IN ssis OLEDB source editor, under sql command text. I have a T-sql like below. Nothing wriong with sql syntax, but when I click at columns only on my first query column are available, then when I try to produce results again only on my first query results are presented. Any advise to get this work in ssis OLEDB ?
select name,add,phone, Count(*) from tabletest
select * from tabletest where date_time='2011-0-01'