如何让 SSIS 数据流每隔 5 分钟频繁执行一次 [英] How to make SSIS Data Flow execute frequently after every 5 minutes

问题描述

我是 SSIS 初学者，我想每 5 分钟后频繁执行一次 SSIS 数据流.

I am a beginner in SSIS, I want to SSIS Data Flow execute frequently after every 5 minutes.

推荐答案

1- 部署 SSIS 包:完成 SIS 包开发后，您可以将其部署到服务器.我们也可以在那里安排和执行包.

1- Deploying the SSIS Package : After you finish your SIS package development, you can deploy it to the server. There we can schedule and execute the package as well.

在 Visual Studio 中，右键单击项目并选择 Deploy :

In Visual Studio, right-click on the project and select Deploy :

这将启动 SSIS 部署向导.请记住，这将部署整个项目，包括所有包.如果要部署单个包，可以右键单击包本身并选择部署"(自 SSIS 2016 起).

This will start the SSIS deployment wizard. Keep in mind this will deploy the entire project, with all packages included. If you want to deploy an individual package, you can right-click on the package itself and choose Deploy (since SSIS 2016).

在向导的第一步中，我们需要选择目的地(自从我们从 Visual Studio 启动向导以来，跳过了几个步骤).输入服务器名称并确保已在该服务器上创建 SSIS 目录.如果需要，您还可以创建一个文件夹来存储项目.

In the first step of the wizard, we need to choose the destination (several steps are skipped since we started the wizard from Visual Studio). Enter the server name and make sure the SSIS catalog has already been created on that server. If you want, you can also create a folder to store the project in.

在下一步中，您将大致了解向导将采取的操作.点击部署开始部署.

At the next step, you get an overview of the actions the wizard will take. Hit Deploy to start the deployment.

部署将经历几个步骤:

项目现在已经部署到服务器，你可以在目录中找到它:

The project has now been deployed to the server and you can find it in the catalog:

2- 在服务器上执行 SSIS 包

手动执行包是一回事，但通常您会调度包，以便您的 ETL 可以在特定时间窗口(可能在晚上)运行.最简单的选择是 SQL Server 代理.您可以右键单击 Jobs 节点以创建新作业:

Manually executing packages is one thing, but normally you will schedule packages so your ETL can run in a specific time windows (probably at night). The easiest option is SQL Server Agent. You can right-click on the Jobs node to create a new job:

在常规"窗格中，输入作业名称，选择所有者并可选择输入说明:

In the General pane, enter a name for the job, choose an owner and optionally enter a description:

在步骤窗格中，您可以创建一个新的作业步骤:

In the Steps pane, you can create a new job step :

在作业步骤配置中，您可以输入步骤的名称.选择 SQL Server 集成服务包类型，输入服务器名称并选择包.

In the job step configuration, you can enter a name for the step. Choose the SQL Server Integration Services Package type, enter the name of the server and select the package.

在配置选项卡中，您可以选择设置更多属性，就像手动执行包时一样.单击确定"保存作业步骤.在计划选项卡中，您可以定义一个或多个计划以在预定义的时间点执行包.单击新建...以创建新计划.在日程编辑器中，您可以在多种日程类型之间进行选择:每天、每周或每月.您还可以安排包只运行一次.在下面的示例中，我们将作业安排在每天凌晨 1 点运行，周末除外.

In the configuration tab, you can optionally set more properties, just like when executing a package manually. Click OK to save the job step. In the Schedules tab, you can define one or more schedule to execute the package on predefined points in time. Click New… to create a new schedule. In the schedule editor, you can choose between multiple types of schedules: daily, weekly or monthly. You can also schedule packages to run only once. In the example below we have scheduled the job to run every day at 1AM, except in the weekend.

在您的情况下，将频率设置为每日，并将作业应运行时发生一次的值设置为每 5 分钟一次.

In your case, set the Frequency to Daily, and set the value of Occurs once at to every 5 minutes when the job should run.

这篇关于如何让 SSIS 数据流每隔 5 分钟频繁执行一次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！