SSIS Script Task EXCEL导出时报错:
[a] Error: System.IO.FileNotFoundException: 无法加载档案或组件 'NPOI.OOXML, Version=2.3.0.0, Culture=neutral, PublicKeyToken=0df73ec7942b34e1' 或其相依性的其中之一。 系统找不到指定的档案。
解决办法:
gacutil -i D:\XXXXX\DLL\ICSharpCode.SharpZipLib.dll
gacutil -i D:\XXXXX\DLL\NPOI.dll
gacutil -i D:\XXXXX\DLL\NPOI.OOXML.dll
gacutil -i D:\XXXXX\DLL\NPOI.OpenXml4Net.dll
gacutil -i D:\XXXXX\DLL\NPOI.OpenXmlFormats.dll