Hi,

Finally i was able to copy all the data from queries to single excel using VB Script and was able to format it as well with borders. Only thing i...

To be read and written to excel. Pls refer the above posts for more details.

Thanks,

Suchitra

My select query will fetch me 2 rows. So what are the changes that should be made in ssis and vb code?

thanks a lot. That really worked. now i can proceed further.

More details

I have a table Reporting and my sample query is Select distinct location from Reporting

For this,

i have declared VarLocation as String,

in Execute SqL task, i have given this query...

That link was really useful. i am planning to get data from execute sql task and then i will put in script task as i will have only 2 rows...

I am also thinking the same. Putting it in different worksheets. but in the second sheet, data from two tables need to be put . on data below the other.

Can you please help me in that? i need all data in a single sheet.

I can have separate data flow. but how do i append the data to the already generated excel? i have separate headers for the other tables.

I have a table...

Forgot to mention that the tables have different formats.