获取错误为“从sql server启动包时发生异常” [英] Getting error as "An exception occurred while launching the package from sql server"

问题描述

您好，

我们有一个SSIS包，它是在MSDB中导入的SQL Server 2012中。我们用c＃代码调用它。现在我们将SQL Server 2012升级到SQL Server 2016并且 在MSDB中导入SSIS包。当我们从.net应用程序调用它时，我们得到
错误为"从sql server启动包时发生异常"。 

We have an SSIS package which was in SQL Server 2012 imported in MSDB. We are calling it from c# code. Now we upgraded SQL Server 2012 to SQL Server 2016 and  imported SSIS Package in MSDB. When we are calling it from our .net application, we getting error as "An exception occurred while launching the package from sql server". 

我们使用的是在SQL Server中拥有足够权限的帐户。我们尝试了各种解决方案，但仍然遇到同样的问题。 

We are using same account which have enough permission in SQL Server. We tried various solution but still getting same issue. 

请帮忙。

谢谢，

推荐答案

嗨  Rajesh Lohar，

从SQL Server 2012及更高版本开始，本机SSIS部署模式进入SSISDB目录。

Starting with SQL Server 2012 and later, native SSIS Deployment Mode is into SSISDB Catalog.

它有很多好处，有很多启动SSIS包的方法，包括通过存储过程启动SSIS包，SSMS，c＃，PowerShell等。请看一下：

It has long list of benefits, many ways of launching SSIS packages, including launching SSIS packages via stored procedures, SSMS, c#, PowerShell, etc. Please take a look here:

这篇关于获取错误为“从sql server启动包时发生异常”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！