Output to different excel tabs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Output to different excel tabs

Output to different excel tabs

Rate Topic

Display Mode

Topic Options

Author

Message

nimmi.smith-624103

Posted Tuesday, May 05, 2009 4:56 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, December 13, 2012 10:16 AM
Points: 32, Visits: 163

I am fairly new to SSIS. I created my first ssis package that outputs sql data to an excel spreadsheet. I need to put outputs from different queries into different tabs in one spreadsheet. I am sure someone out there has done this. Can someone please tell me how to do this?

Post #710736

Phil Parkin

Posted Tuesday, May 05, 2009 9:23 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 4,247, Visits: 9,500

Maybe this article gives you what you need:

http://www.sqlservercentral.com/articles/Integration+Services/61542/

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #710795

« Prev Topic | Next Topic »

Permissions