SSIS 导出到 excel.我需要在目标机器上使用 excel 吗?
我想知道如果我提供一个包含导出到 excel 数据流到第三方的 SSIS 包，他们是否需要在运行包的机器上安装 excel?
I would like to know if I provide a SSIS package that contains a export to excel data flow to a third party, would they require a excel on the machine that the package runs from?
我知道我可以试试这个，但我没有测试机，也没有办公室的副本.希望你们中的一个人知道你的头
I realise I could try this but I dont have a test machine and I dont have access to a copy of office. Was hoping one of you guys knew off the top of your heads
提前致谢
不，导出到 Excel 功能是 SSIS 的本机功能.它确实需要包以 32 位模式执行，但除此之外，它没有外部依赖项.
No, the export to Excel functionality is a native capability for SSIS. It does require the package to execute in 32 bit mode but otherwise, it has not outside dependencies.
但是，如果您发现功能的本机导出...缺少并使用互操作类实现您自己的导出，那么您将需要安装和许可Office 的服务器.您可能会激怒 Windows 管理员，因为这会增加此框所需的修补程序数量和中断时间.您还需要密切关注您的编码，以确保不会出现内存泄漏.C# Excel 自动化导致 Excel 内存泄漏
However, if you find the native export to functionality...lacking and implement your own export using the Interop classes, then you will need to install and license that server for Office. You will probably gain the ire of the windows administrator as this will increase the amount of patches and outage time required for this box. You'll also want to keep a very close eye on your coding to ensure you don't open yourself up to memory leaks. C# Excel automation causes Excel memory leak