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

  • March 12, 2014 at 3:30 pm

    #1696563

    christine.collins 55481 (3/12/2014)

    I am having a little trouble getting this to work.

    I keep getting the 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_2a6e4db473504d2f985a440256eaa3d9.csproj.ScriptMain.Main()

    I added the Reference exactly as you specified.

    I put the files in C:\EPPlus 3.1.3 and the properties in the Script indicate that it is there.

    Add the assembly to the GAC (global assembly cache) as kathypdx said on an earlier post:

    My colleague and I had the same error message ("Could not load file or assembly"). We resolved it by adding the EPPlus assembly to the GAC as described in this article: http://emendezrivas.com/45/ which has a link to these specific instructions: http://emendezrivas.wordpress.com/2011/03/19/add-an-assembly-to-the-gac/[/url]).