从远程2005服务器上的SQL Agent Job调用2008服务器上的SSIS程序包 [英] Call SSIS Package on 2008 server from SQL Agent Job on remote 2005 server

问题描述

我尝试远程执行SSIS包，但未成功.该程序包驻留在SQL Server 2008实例上，我想从2005服务器上的Job中调用它.我收到的错误是:

I'm trying, unsuccessfully, to remotely execute an SSIS package. The package resides on a SQL Server 2008 instance and I'd like to call it from a Job on a 2005 server. The error I'm getting is:

无法加载软件包.这 步骤失败.

The package could not be loaded. The step failed.

如果我从2008年到2008年，则没有错误.有什么想法吗?

If I go from 2008 to 2008, there is no error. Any ideas?

推荐答案

假设您正尝试使用dtexec命令执行程序包，问题是该程序包是在调用服务器而不是服务器上执行的它存储在哪里.

Assuming that you're attempting to execute the package with a dtexec command, the issue is that the package is executed on the calling server, not the server where it is stored.

由于2005 SSIS服务无法执行2008程序包，因此该步骤失败.

Since the 2005 SSIS service can't execute 2008 packages, the step fails.

您需要在要运行作业的服务器上触发dtexec.最简单的方法可能是在启动该程序包的2008服务器上设置SQL Agent作业，然后从2005服务器上触发该SQL作业(使用sp_startjob或更复杂的触发机制).

You need to trigger the dtexec on the server where you want the job to run. The easiest way to do this is probably to set up a SQL Agent job on the 2008 server which starts the package, and trigger that from the 2005 server (using sp_startjob or some more complex trigger mechanism).

这篇关于从远程2005服务器上的SQL Agent Job调用2008服务器上的SSIS程序包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！