Finally!!! It worked! It worked! It worked! There was one silly thing that needed to be changed in my ScriptTask which was the apparent cause (and it...

And this is what i based the zip & email part of the package on: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/

I had changed the variables and paths appropriately which is why it works...

But it doesn't seem to be failing at the point where the .csv actually gets zipped -it fails at the step just prior to that (where i set the variables...

Using 7-zip and it's installed on the same server

hi, did u ever get a response to this question? I'm having pretty much the same issue and cannot find a solution