如何在另一台机器上超越ssis packge？ [英] How to exceute ssis packge in another machine?

问题描述

我已经完成了ssis包的创建，现在我想在另一台机器上执行它，它没有bi..how我们可以在另一台机器上运行包装



请告诉我要完成的过程。非常感谢您的回答。



我尝试过的事情：



我的包装名称是prohect3下的package22请告诉我什么是在另一台机器或服务器上除了包装的程序..

I have done with ssis package creation now i want to execute it in another machine which does't have bi..how we can exute package in another machine

Please tell me the process to be done.any answer would be greatly appreciated.

What I have tried:

my packge name is package22 under prohect3 please tell me what is procedure to exceute package in another machine or server..

推荐答案

将SSIS包部署到现有服务器SSIS目录并在SSISDB数据库中创建一个过程。



并使用过程从您要执行的服务器上执行ssis包而不使用BI。



注意：外部服务器和SSIS包服务器应该已链接。 br />


执行声明如下所示..



执行[dbo]。[Procedurename]

@Login = UserLogin;

，@ folder_name = poc; - 您在SSIS目录中部署的文件夹名称

，@ project_name =项目; - 您在SSIS目录中部署的项目名称

，@ package_name = PKG_Load_extract_GEN.dtsx; - 包名称

，@ FileName = filename_abc.txt; - 参数

，@ Filepath = \\ExternalSource_Production\IT\ETL; --file path --parameters

Hi,

Deploy your SSIS package to existing server SSIS catalog and create one procedure in SSISDB database.

and execute the ssis package from the server where you want to execute without BI by using procedure.

Note: External server and SSIS package server should have linked.

Execution statement looks like below..

Exec [dbo].[Procedurename]
@Login =UserLogin;
,@folder_name =poc; -- Folder name where you deployed in SSIS Catalog
,@project_name =Project;-- Project name where you deployed in SSIS Catalog
,@package_name =PKG_Load_extract_GEN.dtsx; -- Package name
,@FileName =filename_abc.txt; --parameters
,@Filepath =\\ExternalSource_Production\IT\ETL; --file path --parameters

这篇关于如何在另一台机器上超越ssis packge？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！