Link to home
Start Free TrialLog in
Avatar of chokka
chokkaFlag for United States of America

asked on

SSIS Export to Excel

I have 5 set of query

select * from Table1

select * from Table2

select * from Table3

select * from Table4

select * from Table5

At present, i export all the records to seperate spreadsheet. How to generate one excel file with multiple sheets for each set of query.

I can just copy and paste. On doing so, some TEXT Columns, Decimal COlumns are not properly copied. I feel it is safer to go through SQL Export to same excel file
Avatar of als315
als315
Flag of Russian Federation image

You can use UNION query (if columns in all tables are same):
select * from Table1
UNION ALL
select * from Table2
UNION ALL
select * from Table3
UNION ALL
select * from Table4
UNION ALL
select * from Table5
Avatar of chokka

ASKER

This will result in one Sheet.

I want one excel file with multiple sheets like Tab Menu
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chokka

ASKER

Unable to find  the solution.

If i am not wrong, using SSIS we will not be able to export multiple sheets or workbook on one spreadsheet.
Avatar of chokka

ASKER

Not  the solution !!
If it is not a solution, you should not mark question as answered. Press Request attention and ask to set your comment #38738313 as an answer.