SSIS and encrypting text file to winzip

Question

SSIS and encrypting text file to winzip

skudirka

Old Hand

Points: 325
More actions
February 17, 2011 at 12:24 pm

#388886

Using SSIS, I am trying to add a file to winzip and then encrypt it. I can add the file just fine but can't get the encrypt part.
We are upgrading from 2000 to 2005 and in the current DTS package (Active X script) we used:
-a -sUsername-yPassword "File.zip" "File.txt" to add and encrypt the file.
Now in 2005, in my SSIS package I'm using a Script Task and Execute Process Task but when I try to use the -s and -y arguments as well, it tells me they are invalid.
So right now this is what I have as my argument.
-a "File.zip" "File.txt"
and the winzip executable being called from the Execute Process Task.
Like I said, it works for me - it takes my text file and adds it to winzip - creating my zip file.
But I am looking to find out to ALSO add a user name and password (encrypt) as well to the zip file.
Any suggestions or somewhere I can find a list of arguments for winzip using SSIS (encryption) would be appreciated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

niall.baird Hall of Fame Points: 3468 More actions · Answer 1

Have you tried googling the command line parameters? (command line parameters winzip) in google gives this (winzip) as the second result. Without knowing what version of winzip you're using that's about as much as I can help with.

skudirka Old Hand Points: 325 More actions · Answer 2

Yeah I've tried. That is part of my question if anyone knows where I can find the commands line parameters to add and encrypt to winzip. I've looked all over the internet and I can't find anything for winzip and encrypting files. The link you provided doesn't tell me that (at least I can't find it).

I'm using winzip 11.1

Thanks in advance.

niall.baird Hall of Fame Points: 3468 More actions · Answer 3

Hmmm - after doing a bit of searching around the winzip website myself, I've come to the conclusion that there is no commmand line interface for WinZip these days.

However, the good news is that you can use either WinRAR or 7Zip to achieve your aims (both of these will unzip with WinZip if that's what your clients use).

See this website for the command line options for WinRar and 7Zip.

Hope this helps.

skudirka Old Hand Points: 325 More actions · Answer 4

Thanks for your help. I did figure out the encrypt part. I had to put the password in quotes. See below -s is encrypt command.

-a -s"password" "File.zip" "File.txt"

I can't get the encryption type though. Normally you would use -y and then the encryption type which in the DTS package of 2000 we used -ycaes256 to encrypt it to 256-Bit AES encryption . that won't work in ssis.

I'll keep looking.

Thanks again