November 23, 2011 at 10:48 am
Hello,
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.
Rgds,
Pankaj
Rgds,
Pankaj
December 9, 2011 at 4:11 pm
I strongly encourage you to find an alternative way to do what you are attempting.
From http://support.microsoft.com/kb/257757
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply