Update: I think it is the updated wzzip executable used on winzip64 that is the issue.
I had IT Security install the old version of wzzip.exe used for winzip32 and it zipped up the files using the sql script.
Gonna try my package to see if i am not getting an error. Stay tune...