从其中未安装一体化服务的计算机执行SSIS包 [英] executing ssis package from a computer where integration services in not installed

问题描述

我使用code的下面一行在Web应用中集成服务installed.But我无法执行它的应用程序服务器上执行驻留其他服务器上的包。

 字符串pkgLocation;
        Microsoft.SqlServer.Dts.Runtime.Package PKG;
        应用程序;
        DTSExecResult pkgResults;        pkgLocation = @\\\\ hddlntd6021985 \\ SSIS \\ Package1.dtsx        应用=新的应用程序（）;
        PKG = app.LoadPackage（pkgLocation，NULL）;
        pkgResults = pkg.Execute（）;       的Response.Write（pkgResults.ToString（））;
 

解决方案

它始终是远程运行包的一个问题。你有几次机会，但他们都不可以正常工作。 这文章解释你的机会和正反各的利弊。什么你试图做的是第一点。

另一种方式可以使用PowerShell远程的<一个解释href=\"http://blogs.msdn.com/b/dbrowne/archive/2010/10/11/remote-ssis-package-execution-with-powershell-2-0.aspx\"相对=nofollow>这个文章。在我的项目之一，我拼命地跑远程包这种方式，但在和它并不能使用它，因为他们的安全策略。 （PowerShell远程打开端口5985和5986），我认为这是一个简单的解决方案。不是开发数据库服务器上的服务更简单。所以，如果你被允许打开数据库服务器上这些端口，您可以考虑使用PowerShell的。

I am using following line of code in a web application to execute a package which resides on other server where integration service is installed.But I am unable to execute it on application server.

        string pkgLocation;
        Microsoft.SqlServer.Dts.Runtime.Package pkg;
        Application app;
        DTSExecResult pkgResults;

        pkgLocation = @"\\hddlntd6021985\ssis\Package1.dtsx";

        app = new Application();
        pkg = app.LoadPackage(pkgLocation, null);
        pkgResults = pkg.Execute();

       Response.Write(pkgResults.ToString());

解决方案

It is always a problem to run packages remotely. You've got several opportunities but neither of them may work perfectly. This article explains your opportunities and pros and cons of each. What you've tried to do is in the first point.

Another way can be use of PowerShell Remoting explained in this article. In one of my projects I runned remotely a package this way, but at the and the IT did not allowed to use it because of their security policy. (PowerShell Remoting opens ports 5985 and 5986) I think it is a simple solution. More simple than developing a service on the database server. So if you are allowed to open these ports on database server, you may consider using PowerShell.

这篇关于从其中未安装一体化服务的计算机执行SSIS包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！