Compress Dynamic Files Using 7-Zip in SSIS
Abstract This blog post is in response to a request/comment from Thato in this previous article. Hence, I have taken much of the logic used in the aforementioned article and changed it from static to dynamic file compression. Thus, I am still using SQL Server Integration Services’ Execute Process Task to compress dynamic files into a …