Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  How to export data to multiple excel sheets SSIS

Author  Topic  sur200 Starting Member 7 Posts Posted - 2012-06-26 : 02:14:07 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