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'
As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.