how to call excel (2007/2010) macro in SSIS Package (2005/2008)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » SMO/RMO/DMO » how to call excel (2007/2010) macro in SSIS...

how to call excel (2007/2010) macro in SSIS Package (2005/2008)

Rate Topic

Display Mode

Topic Options

Author

Message

pankaj.baluni

Posted Wednesday, November 23, 2011 10:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 23, 2011 10:43 AM
Points: 126, Visits: 124

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

Post #1211219

opc.three

Posted Friday, December 09, 2011 4:11 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 6,703, Visits: 11,731

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

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 »

Permissions