• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 677
  • Last Modified:

SSISto transfer from SQl Table into Multiple Excel Sheets

Hi,
I have a table with some data in Management Studio.  I am trying to understand how I can transfer data from one table in Management Studio into multiple excel sheets(not multiple excel files). Could you please guide me through this process. The data resides in 3 different categories in the table. Total, Old and New. I would like to have the 'total' transferred into sheet1, 'old' into sheet 2 and 'new' in sheet 3. These catogories are differentiated by filters in my sql command.

Thnaks in advance
0
Josh2442
Asked:
Josh2442
  • 2
  • 2
1 Solution
 
DcpKingCommented:
Keith writes it better than I can, and anyhow, it would be far too long an anwer for here!

http://www.bidn.com/blogs/KeithHyer/bidn-blog/2512/creating-excel-worksheets-dynamically-in-ssis

hth

Mike
0
 
Josh2442Author Commented:
Thanks for this great article
0
 
DcpKingCommented:
Thats what I thought when I found it, Josh. The real problems come when you try to have fancy headers and lots of data on the same worksheet!
0
 
Josh2442Author Commented:
I will keep that in mind. Thanks again
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now