Thanks .It works .Is it same as using parameter @execute_query_database?

Thanks for the suggestions .I have lots of reports to create and I think with this approach I will need two schedules for each report and anytime the job fails...

Thanks for the reply.

I will need each result set in case the query returns any results.

lets say out of 50 queries 5 give some results so i will need 5...

Thanks or the help .Because of excel issues ,I was thing of a way of creating the excel file via SSRS i.e SSIS has a step to connect to SSRS...

You are correct here when it is a simple case of just getting the data and emailing the report SSRS works but there are jobs for which I have to...

Thanks for the reply .Any pointers for how can I achieve this ?

Call SSRS report i.e rdl file from SSIS ?

Thanks,

Yes I had a where clause for table B.I removed it as per your suggestions and it works:-)

Thanks for your help

thanks for the reply.I am doing the same thing but still i am not geting all rows present in Table a .

I am geting only those for which the count...

Thanks it works