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.