是否可以远程执行 SSIS 包? [英] Is it possible to execute an SSIS package remotely?
问题描述
我想从另一台计算机执行存储在 SQL 服务器 (2008 R2) 上的 SSIS 包.但是，我在网上找到的所有内容都涉及从服务器加载包，然后在本地运行.
I want to execute an SSIS package stored on an SQL server (2008 R2) from another computer. However, everything I've found online involves loading the package from the server and then running it locally.
是否可以在服务器上运行该软件包?感谢任何资源.
Is it possible to run the package on the server? Any resources are appreciated.
推荐答案
要执行包，您通常会创建一个新作业并使用作业步骤来启动所需的包.
To execute a package, you normally create a new job and use a job step to start the desired package.
如果您在远程计算机上安装了 sql server management studio(ssms)，您只需连接到数据库引擎并开始工作.或者，您可以使用 ssms 连接到集成服务并直接启动包.
If you got the sql server management studio(ssms) installed on your remote computer, you simply connect to the database engine and start the job. Alternativly, you can connect to the integration services with ssms and start the package directly.
如果没有可用的 ssms，您可以使用存储过程 sp_start_job 启动作业.您可以使用类似 this 之类的东西来执行.
If there is no ssms available, you can start the job using the stored procedure sp_start_job. You could use something like this to execute.
这篇关于是否可以远程执行 SSIS 包?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
