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

  • As an extra on this...

    I went back to the original error in the Integration Services script package

    The Binary Code for the script is not found. Please open the script in the designer by clicking edit script button and make sure it builds successfully

    I hadnt realised I could click Build so I did and now I have a new error coming up (Which is at least getting somewhere)

    Statement is not valid in a namespace.

    Using this I think I might have found a forum post that does what I need. Gives you the extra bit of script and shos you where the code goes

    http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/87f896aa-5fff-40d3-a054-b0cc4d742ad4

    Im not totally sure yet as I havent tested it but that was what I should have done... Clicked build and then used this to get further errors