none
Bring data from SQL db to Blob to Azure SQL DB (Not ADW)

    Question

  • Hi 

    What are the ways to achieve this task, in Data factory or SSIS?

    Bring data from a view present in SQL db to Azure Blob and finally to Azure SQL DB (Not ADW).


    Royal Thomas

    Friday, May 11, 2018 8:37 PM

All replies

  • You can convert the view into table first using the below query:

    SELECT * INTO [TABLE NAME] from [VIEW NAME];

    Then you can use this document as a guide to achieve your task

    Friday, May 11, 2018 10:29 PM
    Moderator
  • You can use ADF Copy Wizard feature (its available on the landing page of your ADF). you can select source/destination and use Views as source query "select * from view".
    Saturday, May 12, 2018 3:31 AM