My situation : -
Excel 2007 and 2010
MSBI - 2005 and 2008 (EE/SE)
Excel based macro has been written in above mentioned versions of excel.
Script Task : -
marco would copy and paste data from different sheets of 3 different excel files to one sheet to make it one consolidated data.
Requirement : -
Need to run those macros using SSIS on the excel file.
Please send me step by step process to do it.