Josh2442
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
ASKER
I will keep that in mind. Thanks again
ASKER