在非 SSIS 服务器上运行 SSIS 包时出错 [英] Getting error running SSIS package on non-SSIS Server

问题描述

我在 SSDT 2012 中工作.我创建了一个 DTSX 包，我已将其部署到未安装 SSIS 的 SQL Server.我的理解是这应该有效.

I'm working in SSDT 2012. I've created a DTSX package that I have deployed to a SQL Server that does not have SSIS installed. My undertstanding is that this should work.

但是我不断收到以下错误:要在 SQL Server Data Tools 之外运行 SSIS 包，您必须安装 Derived Column of Integration Services 或更高版本.

However I keep getting the following error: To run a SSIS package outside of SQL Server Data Tools you must install Derived Column of Integration Services or Higher.

我不太确定这里发生了什么.有没有人对此有任何见解.我已经要求我们的 DBA 在机器上安装 SSIS，但我只是猜测.这可能行不通，如果可以，我想先行一步.

I'm not really sure what's going on here. Does anyone have any insight for this. I've asked our DBA to install SSIS on the machine but I'm only guessing. This may not work and I would like to get ahead of this if I can.

感谢您的任何反馈.

推荐答案

要在服务器上执行包，您需要在服务器上安装 SQL Server Integration Services 引擎.

For the package to execute on the server, you do need to have SQL Server Integration Services engine installed on the server.

这篇关于在非 SSIS 服务器上运行 SSIS 包时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！