How to export data from SQL Server SSIS to Parquet file format and compress it using Snappy

Question

the challenge is to export data from SQL Server SSIS to Parquet file format and compress it using Snappy. The expected list of tables to exported to Parquet file are 650.

Answer 1

Hi @Mohammed Aslam Yousuf Hussain,

If you are using Azure Data Factory, you can refer to the following link to Copy data from a SQL Server database to Azure Blob storage.

If you are using SSIS, there is no parquet destination component to be able to write data into parquet files directly.

You may consider using SSIS to load the tables to txt file or csv file first and then convert a csv or a txt file to parquet format.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.