Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS Export to Excel

Posted on 2013-01-02
6
Medium Priority
?
531 Views
Last Modified: 2016-02-10
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
0
Comment
Question by:chokka
  • 3
  • 3
6 Comments
 
LVL 40

Expert Comment

by:als315
ID: 38736693
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
 

Author Comment

by:chokka
ID: 38736703
This will result in one Sheet.

I want one excel file with multiple sheets like Tab Menu
0
 
LVL 40

Accepted Solution

by:
als315 earned 1000 total points
ID: 38736784
Sorry, didn't read question carefully. Try this solution:
http://stackoverflow.com/questions/3891650/exporting-to-multiple-worksheets-using-ssis
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:chokka
ID: 38738313
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
 

Author Closing Comment

by:chokka
ID: 38738316
Not  the solution !!
0
 
LVL 40

Expert Comment

by:als315
ID: 38739123
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question