Azure Data Factory - Text File import into Azure SQL table with some columns encrypted RRS feed

  • Question

  • I have managed to setup text files from an ftp site to be imported into Azure SQL Database tables using Azure Data Factory.

    New requirements have meant I have had to encrypt columns for certain tables in Azure Database using always encrypted. The keys are in Azure Data Vault. However now my Azure Data Factory pipeline for text files that are copied into Azure SQL Database tables with some columns encrypted is now failing.

    Please may someone help me to solve how to correct my existing Azure Data Factory to allow for importing text files into an Azure SQL Database with some columns encrypted.

    Tuesday, June 13, 2017 7:58 AM