通过ADF SSIS Integration运行时使用SSIS移动数据 [英] Move data using SSIS via ADF SSIS Integration runtime

问题描述

Hello Everyone，



我对我的工作有以下要求，因为我对SSIS有所了解，但对Azure数据工厂了解不多。



要求：



我将获得Excel文件On-Prem.My任务是将Excel文件复制到Blob.As根据我的理解，我可以使用Azure上传任务创建正常的SSIS包。但客户说他想要使用ADF SSIS Integration Runtime。

所以，你能否告诉我它是如何不同的来自其他人。



一旦文件在Azure blob中可用，我需要将所有数据复制到Azure SQL中。

Hello Everyone,

I have a following requirement for my work as I have a knowledge about SSIS but not much aware about Azure data Factory.

Requirement :

I will get Excel files On-Prem.My task is to copy Excel files to Blob.As per my understanding I can create normal SSIS package with Azure upload task.But Client is saying that He wants to use ADF SSIS Integration Runtime for the same.
So, Can you please tell me how It is different from others.

Once Files will be available in Azure blob, I need to copy all data into Azure SQL.

推荐答案

你好Aminesh，谢谢你的问题。  

Hello Aminesh, thank you for your question.  

本文档解释了三种类型的运行时可用。

https://docs.microsoft.com/en- us / azure / data-factory / concepts-integration-runtime

This document explains the three types of runtime available.
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

以下是一些有关创建运行时的教程。

Here are some tutorials on creating the runtimes.

https://docs.microsoft.com/en-us/azure/data-factory/create-azure-ssis-integration-runtime < span style =""> https://docs.microsoft.com/en-us/azure/data-factory/create-shared-self-hosted-integration-runtime-powershell

从内部迁移到blob存储的教程：

https://docs.microsoft.com/en-us/azure/data- factory / tutorial-hybrid-copy-portal

And a tutorial for moving from on-prem to blob storage:
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-portal

我希望这会有所帮助。 如果您有任何其他问题，请与我们联系。

I hope this helps.  Let me know if you have any additional questions.

这篇关于通过ADF SSIS Integration运行时使用SSIS移动数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！