Home Forums Data Warehousing Integration Services IS 2008 Triggering an Excel Macro via Script Task - The Binary Code for the script is not found RE: IS 2008 Triggering an Excel Macro via Script Task - The Binary Code for the script is not found

  • March 6, 2013 at 10:07 am

    #1594062

    Debbie Edwards (3/6/2013)

    Im horribly close to having to sign this off as a no can do at the moment which is really dissapointing.

    From what I can gather I possibly need to execute the VBA Script using c# script within the IS Task but again there seeems to be no documentation on how to do this.

    But Again I cant get enough out of the information I have to know that that is right

    🙁

    You need a Script Task in SSIS which will perform the Excel automation for you. This task would need to effectively load the spreadsheet in Excel - programmatically - and call the macro. That's roughly what the link I posted was doing - albeit from a native C# app rather than a script task (should not be much difference).

    Without C# or VB skills, I believe you will struggle to complete this task, I am afraid.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.