Hi, i want to create an SSIS package loading data from sql to excel and will use a table having columns like ExcelFileName, ExcelSource, ExcelDestination etc.. do you guys know any example on this? i checked online found some links but didnt understand well. Thanks

You can use SSIS Package Configurations to influence the properties of the Excel connection manager. See http://msdn.microsoft.com/en-us/library/ms141682(v=sql.105).aspx for more info. Farooq Mahmud | Support Escalation Engineer | Microsoft Health Solutions Group