通过ADF SSIS Integration运行时使用SSIS移动数据

本文介绍了通过ADF SSIS Integration运行时使用SSIS移动数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 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.推荐答案本文档解释了三种类型的运行时可用。 https://docs.microsoft.com/en- us / azure / data-factory / concepts-integration-runtimeThis 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 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-portalAnd 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移动数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！