从Azure运行SSIS包 [英] Run SSIS packages from Azure

问题描述

我们已经拥有一个包含7个控制流的SSIS包，每个包都采用本地存储的文件，并在一些转换后将数据存储到各种SQL服务器表。

我们计划更改SSIS，以便从azure数据湖中获取intput文件并执行相同的转换，最后将数据存储到SQL Server。据我了解，我们需要创建一个Azure-SSIS集成运行时，但是我们是否必须在Azure上创建一个SSISDB
来运行SSIS中的包？

 

解决方案

嗨PStev，

创建Azure-SSIS集成运行时后，可以使用SQL Server数据工具（SSDT）或SQL Server Management Studio（SSMS）将SSIS包部署到Azure。将
连接到承载SSIS目录（SSISDB数据库）的Azure SQL数据库服务器。

注意： Azure数据工厂在此数据库服务器上创建SSIS目录（SSISDB数据库）
。我们建议您在与集成运行时相同的Azure区域中创建数据库服务器。此配置允许集成运行时将执行日志写入SSISDB数据库，而不会跨越Azure区域。

这个

文章描述了如何使用执行SSIS包活动在Azure数据工厂管道中运行SSIS包。

希望这有帮助。

We already have an SSIS package having 7 control flows with each of them taking a file that is stored locally and after some transformations stores data to various SQL server tables.

We plan on changing the SSIS as to take the intput files from an azure data lake and perform the same transformations and finally store data to SQL Server. As I understand it we need to Create an Azure-SSIS integration runtime, but do we have to create an SSISDB on azure to run the package from SSIS?

 

解决方案

Hi PStev,

Once you create Azure-SSIS integration run time, you can use SQL Server Data Tools (SSDT) or SQL Server Management Studio (SSMS) to deploy your SSIS packages to Azure. Connect to your Azure SQL Database server that hosts the SSIS Catalog (SSISDB database).

Note: Azure Data Factory creates the SSIS Catalog (SSISDB database) on this database server. We recommend that you create the database server in the same Azure region as the integration runtime. This configuration lets the integration runtime write execution logs to the SSISDB database without crossing Azure regions.

This article describes how to run an SSIS package in an Azure Data Factory pipeline by using an Execute SSIS Package activity.

Hope this helps.

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