Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

how to call excel (2007/2010) macro in SSIS Package (2005/2008) Expand / Collapse
Posted Wednesday, November 23, 2011 10:48 AM



Group: General Forum Members
Last Login: Wednesday, November 23, 2011 10:43 AM
Points: 126, Visits: 124
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.


Post #1211219
Posted Friday, December 9, 2011 4:11 PM



Group: General Forum Members
Last Login: 2 days ago @ 2:36 AM
Points: 7,933, Visits: 14,357
I strongly encourage you to find an alternative way to do what you are attempting.


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
Post #1219733
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse