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
chokkaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
als315Connect With a Mentor Commented:
Sorry, didn't read question carefully. Try this solution:
http://stackoverflow.com/questions/3891650/exporting-to-multiple-worksheets-using-ssis
0
 
als315Commented:
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
0
 
chokkaAuthor Commented:
This will result in one Sheet.

I want one excel file with multiple sheets like Tab Menu
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
chokkaAuthor Commented:
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.
0
 
chokkaAuthor Commented:
Not  the solution !!
0
 
als315Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.