Hi,

My Requirement ,In Source Database 5 tables are there ( Emp,Loc,dept,Time,Product ), Destination is Single Excel file.

But Dynamically how to load each table information to load into each sheet wise through SSIS Package?

Please share me your Ideas??

Regards

Rama

+91-9618181144

Hi Rama,

For just five tables it is not worth the automation.

Otherwise it is hard work and most of it is on the Excel interchangeability which is better be done uisng C#/VB as a Console App, not in SSIS.

Excel after all is a desktop app and not data interexchange medium

Interesting.  I've never thought about this before, but I guess you could try a couple things. 

#1)  You could certainly use Power Pivot, if you have Excel 2013.  See the link below.

http://searchsqlserver.techtarget.com/feature/Importing-SQL-Server-data-into-PowerPivot-for-Excel

#2)  If you don't have 2013, don't worry, just use VBA, which has been around since around 1997 or so.  I'm pretty sure your version of Excel can handle the task.  See this link below, and work your way down from the beginning to the end.

http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm#Introduction

#3)  You can try this as well.

http://kildrummy.com/how-to-pulling-export-data-into-excel/