tags:

views:

4

answers:

0
Q: 

Exporting to multiple worksheets using SSIS

I'm just starting out in SSIS, and I was just wondering if it's quite straightforward to use 2 SQL queries to create 2 worksheets in 1 workbook using SSIS, or whether I should suggest another way to produce the data.

related questions

How to turn on FastParse in SSIS (SQL Server Integration Services)
Recommend ONE favorite SSIS component that does SFTP/FTPS
SSIS: Remove Duplicates from Flat File
SSIS read flat file, write to DB or C# app,mutli thread read/write?
SSIS gurus: Links to Great Learning Content requested
Potential Pitfalls of inserting millions of records into SQL Server 2005 from flat file
The best way for a SSIS ftp task to not fail when there are no files to copy
SSIS: How to progmatically direct work flow in dtsx package
SSIS Package Puzzle
Import *variable record length* CSV file using SSIS
Using SSIS to refresh a training database from a production database
What are the options for extracting data out of Hyperion 7.3 with SSIS
SSIS Oracle Parameter Mapping
Integration Services: Multiple-step OLE DB operation generated errors
How to insert a row into a dataset via SSIS
SSIS copy directory from FTP location to a shared network location
SQLServer Native Client Error "Connection Busy With Results From Another Command" in SSIS
How Do I Check Job Status From SSIS Control Flow?
How do I get SQL Server Integration Services to use a different database connection for Package Configuration
Can you start a scheduled Windows task from SQL Server Integration Services ?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
SSIS convert image blob
Good Starting Places for SQL Server Alerts/Notifications?
Accessing Excel data source running SSIS package on 64 bit server
Execute stored procedure (SQL 2005) and place results into a CSV file on a FTP location