How to export data to multiple existing Excel sheets

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » How to export data to multiple existing Excel...

How to export data to multiple existing Excel sheets

Rate Topic

Display Mode

Topic Options

Author

Message

surindersinghthakur

Posted Monday, June 25, 2012 11:27 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 3:12 AM
Points: 9, Visits: 57

Hi,
First of all, I am very new to SSIS and this is my first package.

I have input excel having around 60 columns with data.

Now I am having destination excel with multiple sheets (10 sheets).

I have to export data from existing excel into these multiple sheets based on mapping to each column.

I have to do it using SSIS.

Will you please guide me what is better way to do it.

by using excel source and destination, I can export to one sheet only, but I want to export to multiple sheets.

TIA,
Surinder Singh

Post #1321014

« Prev Topic | Next Topic »

Permissions