Monday, February 17, 2014

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'xxxxxx.dll, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7e7edcc6a6871fc7' or one of its dependencies. The system cannot find the file specified

  • Check whether the DLL is deployed successfully in GAC (Global Assembly Cache)
  • If not make sure that the DLLs are available in the following locations
    • D:\Program Files\Microsoft SQL Server\100\DTS\Binn (depending on the version of SSIS)
    • D:\Program Files (x86\Microsoft SQL Server\100\DTS\Binn (depending on the version of SSIS)
  • Also make sure that the DLL is compiled for the right platform (32-bit or 64-bit or both)

No comments:

Post a Comment