C#从asp.net运行SSIS包中的问题 [英] problem in Running SSIS package from asp.net with C#

问题描述

我在从asp.net运行SSIS包时遇到一个问题.
在构建并运行解决方案后，如果单击执行"按钮，则整个过程(从ASP.Net激活SSIS程序包)都可以正常工作.
但是，将网站托管在IIS中之后，通过浏览选项访问网站并单击执行"按钮将导致无效.
在另一种情况下，我已经在文件系统中部署了SSIS包，并尝试从托管网站访问它.结果导致失败"，尽管在我将SSIS pkg部署到SQL Server之后就可以了，但是，我不知道如何从asp.net访问SQL Server中已部署的pkg.
如果您有任何答案，请帮助...

我尝试的路径是UNC
例如:〜\\ Package \ Package.dtsx

kiran.L

i am facing one problem in Running SSIS package from asp.net.
After build and running the solution if I click on the execute button, the whole thing (activating SSIS packages from ASP.Net) works fine.
But, after hosting the web site in the IIS, then accessing the site via browse option and clicking on execute button results in void.
In another case I have deployed SSIS package in the file system and tried to access it from the hosted web site. It results in ''Failed ''Though it had worked after I deployed the SSIS pkg in SQL Server, but, I dont know how to access that deployed pkg in SQL server from asp.net.
If you have any answer, then please help...

the path which i tryed is UNC
ex:~\\Package\Package.dtsx

kiran.L

推荐答案

从Visual Studio运行asp.net Web应用程序时，将使用您的帐户激活SSIS程序包，因为该网站在您的登录名下运行.凭据.

但是，当您将网站部署到IIS时，它将在Windows 2003中的网络服务"帐户和Windows XP中的"ASPNET"帐户下运行.因此，您需要提供对SQL Server中这些帐户的访问权限.

When you run your asp.net web application from Visual Studio, SSIS package will be activated using your account as the web site is running under your login credentials.

But when you deploy your web site to IIS, It will run under Network Service account in Windows 2003 and ASPNET account in Windows XP. Therefore you need to provide access to these accounts in SQL Server.

这篇关于C#从asp.net运行SSIS包中的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！