locked
Move data using SSIS via ADF SSIS Integration runtime RRS feed

  • Question

  • 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.
    Friday, February 15, 2019 7:28 AM

All replies

  • Hello Aminesh, thank you for your question.  

    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-runtimehttps://docs.microsoft.com/en-us/azure/data-factory/create-shared-self-hosted-integration-runtime-powershell

    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.

    Friday, February 15, 2019 11:49 PM
  • Hi,

    To use the Azure Data Factory(ADF) to copy the file to blob you need to create a gateway between on-premises and Azure.

    There is a component in ADF called Integration Runtime which can help you to create this gateway. All you need to do is to use ADF to create a pipeline having copy data activity. Which ADF are you planning to use v1 or v2?

    In both cases, you can create the integration runtime gateway. More information is available in the following link: ADF Integration Runtime.

    Once this gateway is created, you can create a pipeline having input dataset as on-premises location of file and output dataset as Azure blob. Executing the same will land the file in the mentioned blob container.

    Then, to copy the data in blob into Azure SQL database you need to create another pipeline having input as blob and output as Azure SQL DB. To configure such inputs you need to create linked services.

    Link for the same: Copy Data using ADF

    Regards,

    Pratik


    Saturday, February 16, 2019 7:35 AM