Share via

dataset is using azuresqldatabase linked service type with sql encryption, which is not supported in data flow sink

Bommisetty, Rakesh (Hudson IT Consultant) 170 Reputation points
2023-04-24T10:19:20.1733333+00:00

Hi, when i am using dataflow in ADF at sink place i am getting this below error. source as azuresql and sink also azuresql but am unbale to success the pipeline. Error details: dataset is using azuresqldatabase linked service type with sql encryption, which is not supported in data flow sink

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,218 questions
Accepted answer
  1. Sedat SALMAN 13,350 Reputation points
    2023-04-25T10:29:26.03+00:00

    The Azure SQL Database linked service type with SQL encryption is currently not supported for use as a sink in ADF Data Flows. To resolve this issue, you can try the following workaround:

    • In your Azure SQL Database, disable Transparent Data Encryption (TDE) or Always Encrypted
    • Create a new ADF pipeline using Copy Activity instead of Data Flow Activity. Copy Activity supports Azure SQL Database linked service with SQL encryption as both source and sink.
    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vedant Hosamani 0 Reputation points
    2024-07-29T06:52:36.74+00:00

    User's image

    select "Legacy" rather than Recommended

    0 comments