Azure数据工厂SSIS集成运行时启动 [英] Azure Data Factory SSIS Integration Runtime Start Up

问题描述

我正在尝试通过IR从ADF运行SSIS包。 

I am trying to run SSIS packages from ADF via IR. 

数据量非常小（事实表< 500万条目每月增长200-300k ）并且我的ETL不容易安排，因为数据每个月都在不可预测的时间进入。因此，当文件被放入
a存储帐户时，我需要能够启动和停止IR，以避免每天运行IR 8+小时的费用。

Data volumes are very small (fact table < 5 million entries growing 200-300k per month) and my ETL is not easily scheduled because data comes in at unpredictable times each month. So I need to be able to start and stop the IR when a file is dropped into a storage account to avoid the costs of running IR 8+ hours a day.

问题是启动和停止集成运行时需要大约30分钟，这将极大地限制灵活性。有没有办法减少启动时间或是一个很难的技术限制？如果这是一个严格的限制，有没有其他选择？

The issue is that it takes ~30 minutes to start and stop the integration runtime, which would significantly limit flexibility. Is there a way to decrease the start up time or is it a hard technical limitation? If it is a hard limitation, are there any alternatives?

提前谢谢你，

Daniel

推荐答案

嗨Daniel，

注意： 启动Azure-SSIS IR大约需要20分钟。

这个

article 介绍如何使用Azure数据工厂（ADF）计划Azure-SSIS集成运行时（IR）的启动和停止。

This article describes how to schedule the starting and stopping of Azure-SSIS Integration Runtime (IR) by using Azure Data Factory (ADF).

希望这会有所帮助。

这篇关于Azure数据工厂SSIS集成运行时启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！