Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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 09, 2011 4:11 PM



Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:17 AM
Points: 7,070, Visits: 12,522
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1219733
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse