Ssis

It’s possible! # I’ve been looking for the best way to zip files using SSIS for a while now. Every time I search, however, the recommended solution has always been to use the Execute Process task and call 7-Zip (or your favorite zip utility) either directly or using a .bat file. This has been working just fine so far, but I’ve been on a bit of a mission to remove as many unnecessary third-party dependencies from the server as I can.

Do you ever get Excel files where the sheet name changes on you every single time? It’s like a never-ending puzzle in my ETL workflows, and trying to automate it? Nightmare. I know, I know, you’ll probably say ditch Excel, but good luck telling that to the clients. But guess what? SSIS has a slick trick up its sleeve to deal with this mess – scripting to the rescue!