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

  • 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

  • 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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply