Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Output to different excel tabs Expand / Collapse
Author
Message
Posted Tuesday, May 5, 2009 4:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:17 PM
Points: 32, Visits: 172
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
Posted Tuesday, May 5, 2009 9:23 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:52 PM
Points: 5,317, Visits: 12,353
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.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #710795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse