Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp Create/write to an Excel 2007/2010 spreadsheet from an SSIS package RE: Create/write to an Excel 2007/2010 spreadsheet from an SSIS package

  • February 11, 2014 at 3:01 am

    #1687819

    t.mozelt (2/11/2014)

    Hi,

    thanks for your interesting article! I would like to run your test scenario but I am stuck with following error:

    ...

    Error: 0x1 at Script Task: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'EPPlus, Version=3.1.3.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' or one of its dependencies. The system cannot find the file specified.

    File name: 'EPPlus, Version=3.1.3.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'

    at ST_ff7fa3f713524285b0356dc135d66b25.csproj.ScriptMain.Main()

    ...

    Does anyone have a hint for me?

    many thanks, Thomas

    Did you download the EPPlus files and set the reference correctly?

    the package might not retain the DLL files internally so you will need to make sure that the DLLs are available on all target servers