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

• pankaj.baluni

  Ten Centuries

  Points: 1014

  More actions

  November 23, 2011 at 10:48 am

  #99936

  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

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  December 9, 2011 at 4:11 pm

  #1419655

  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