安排 SSIS 包执行 [英] Schedule SSIS package execution

查看：45 发布时间：2021/7/16 19:11:53 ssis scheduled-tasks

本文介绍了安排 SSIS 包执行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

如何安排 SSIS 在每天的给定时间自动从文件执行包?

How do I schedule SSIS to automatically execute a package from a file at a given time every day?

你有几个选择，但我会给你一些让你快速启动和运行的东西......

You have a few options, but I'll give you something that will allow you to get up and running quickly...

打开 SQL Server Management Studio 并连接到将运行作业的 SQL Server 的数据库引擎.此 SQL Server 应安装并运行 SQL Server 代理.
展开 SQL Server 代理，展开作业.
右键单击，选择新建作业.
创建包步骤时，为类型选择SQL Server 集成服务包.对于包源，选择文件系统.然后对于 Package，您可以使用浏览按钮 (...) 在文件系统上浏览 DTSX 文件.
转到计划并像通常为任何其他 SQL Server 代理作业一样创建作业计划.在您的情况下，将频率设置为每天，并将发生一次的值设置为作业应该运行的任何时间.

Open SQL Server Management Studio and connect to the Database Engine of the SQL Server that will run the job. This SQL Server should have SQL Server Agent installed and running.
Expand SQL Server Agent, expand Jobs.
Right-click, select New Job.
When you create your package step, for Type choose SQL Server Integration Services Package. For the Package source, choose File system. Then for the Package you can use the browse button (...) to browse for the DTSX file on the file system.
Go to Schedules and create job schedules as you normally would for any other SQL Server Agent job. In your case, set the Frequency to Daily, and set the value of Occurs once at to whatever time the job should run.

需要记住的几件事...

A couple of things to keep in mind...

Make sure that the SQL Server Agent service account (this is the default, you can choose an alternative security context if needed) has the permission to access the dtsx package on the filesystem.
This will only work if the server on which you're scheduling the job is also the Integration Services server. There are plenty of ways to handle remote package execution if you require it.

这篇关于安排 SSIS 包执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文