Extract SQL Server Data to CSV files in SSIS (Bulk export) and compress/upload files to Amazon S3 (AWS Cloud)

SSIS Data Load – SQL Server to Azure Blob (Split Files, GZip)

Introduction In this blog post you will see how easy it is to load large amount of data from SQL Server to Azure Blob Storage using SSIS. We will export / compress data to multiple files. For demo purpose we will use SQL Server as relational source but you can use same steps for any […]

How to Compress multiple files using SSIS Zip file Task (Encrypt using Password)

SSIS Zip File Task – Compress files and password protect

Introduction In this blog post we will see how to compress files and encrypt with password (zip and encrypt using AES algorithm). We will use SSIS Zip File Task which comes with many advanced options including encryption feature for password protected zip files. NOTE: Password feature is only available for Zip file format. If you […]