Introduction In this article, we will cover the points on how to load 10 million rows from SQL Server to Snowflake in just 3 minutes. Snowflake is a data warehousing platform that resides in a cloud. Basically, it is a data warehouse software exposed as a service. It allows integrating many data sources via internal […]
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 […]