从C＃执行SSIS包 - 出现错误'要在SQL Server数据工具之外运行SSIS包，必须安装标准版的Integration Services或更高版本。 [英] Executing SSIS package from C# - getting an error 'To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher.'

问题描述

我正在尝试从C＃代码执行SSIS包，但是 收到错误'要在SQL Server数据工具之外运行SSIS包，您必须安装标准版的Integration Services
或更高。 SSIS包包含fileSource，文件目标和scriptComponent。 

它没有工作脚本
组件 。我已经安装了SQL Server 2017开发人员版和SSDT。

解决方案

你好，

您需要确保安装了MS SQL Server的SSIS组件。

请看这里如何检查安装的内容：

https://blogs.msdn.microsoft.com/samlester/2013/06/13 / sql-server-2012-discovery-report-determination-what-sql-server-components-installed-installed /

它也适用于SQL Server 2017。

您可以在此处找到它：

Hi,

I am trying to execute SSIS package from C# code but  getting an error 'To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher.; SSIS package contains fileSource, file destination and scriptComponent. 

It is working without script component. I have installed SQL server 2017 developer edition and SSDT.

解决方案

Hi there,

You need to make sure that SSIS component of MS SQL Server is installed.

Please take a look here how to check what is installed:

https://blogs.msdn.microsoft.com/samlester/2013/06/13/sql-server-2012-discovery-report-determining-what-sql-server-components-are-installed/

It applicable to the SQL Server 2017 too.

You can find it here:

这篇关于从C＃执行SSIS包 - 出现错误'要在SQL Server数据工具之外运行SSIS包，必须安装标准版的Integration Services或更高版本。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！