Share via

Transformation where source and sink both are on-prem sql server

Shivani Tyagi 106 Reputation points
2022-10-05T15:02:16.073+00:00

Hi,

This is quite urgent issue that I have come across. We are currently moving from SSIS to Azure Data Factory. I am trying to create a transformation where my source and sink are both in on-prem sql server. But I am getting this error -

Linked service with Self-hosted Integration runtime is not supported in data flow. Please utilize the Azure IR with managed vnet

Does anyone know how to proceed with this ?

Any help is highly appreciated.

Thanks,

Shivani Tyagi

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
0 comments
Accepted answer
  1. Samy Abdul 3,376 Reputation points
    2022-10-05T15:22:08.367+00:00

    Hi @Shivani Tyagi , the dataflow source should be using Azure Integration runtime

    not the Self hosted IR. Please change the source dataset by editing the linked service

    in the dataset linked service pane to Azure IR. Thanks

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.