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 […]
Introduction In this blog post, we will see how to compress and encrypt files with a password (zip and AES). We will use the SSIS Zip File Task, which comes with many advanced options, including an encryption feature for password-protected zip files. NOTE: The Password feature is only available for the Zip file format. If you […]