通过 SSIS 作业执行批处理命令

问题描述

我需要通过 SSIS 作业执行批处理文件.以前我们在cmd提示符下这样做，有什么办法可以通过ssis作业运行批处理文件

I need to execute an batch file through SSIS job. previously we used to do this in cmd prompt, is there any way that we can run batch file through ssis job

推荐答案

在控制流中使用 Execute Process Task 来执行此操作.

Use an Execute Process Task in your Control Flow to do this.

• 在 SSIS 中创建一个新包
• 您将从控制流开始
• 从工具箱中拖出一个Execute Process Task(如果工具箱没有打开，用Menu -> View -> Toolbox) 到控制流
• 您可以在RightMouseButton on the Task -> Edit... -> Process -> 中设置批处理文件路径可执行

• Create a new package in SSIS
• You will start with the Control Flow open
• Drag an Execute Process Task from the Toolbox (if the Toolbox is not open, open it with Menu -> View -> Toolbox) to the Control Flow
• You can set the batch file path in RightMouseButton on the Task -> Edit... -> Process -> Executable

有关 SSIS 的进一步说明，请访问例如微软

For further instructions on SSIS go to e.g. Microsoft

这篇关于通过 SSIS 作业执行批处理命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！