How to Import Binary File to SQL DB

Question

I'm using an ADF pipeline to export a gz csv file from an SFTP to Azure Storage Explorer. It's unzipped as a binary csv file. I can't unzip it as a blob csv file. How do I import a binary file into Azure SQL Server?

Answer 1

Hi @Lilly W ,

Thank you for the ask. I am a little confused with the requirements here. Based on my understanding, you can move the file as unzipped. My guess is, you are trying to move with Binary Dataset. If you create a Delimited text Dataset as a SOURCE -->with Compression type: gzip and then another Delimited text Dataset for the SINK --> Compression type: none, you will able to drop the gzip file as unzipped. For both Dataset, do not import the schema (just clearout if there is any). Please see the screenshots below. Hope this helps. Thank you!