Hi everyone, I have an ssis package that sends the xls file daily, but the file is too large, so it is being sent. How can I compress a file and automate ssis to send it daily
There is no built-in support for this. The easiest way is to download a component that will do this for you like this
Or you can write your own code in a script task. Here you have an example for zip and emailing the file that you need