July 26, 2012 at 3:19 pm
Recently I downloaded 7zip to use to decrypt archives.
Has anyone an example of how to pass in the password into the arguments within a SSIS package?
I see an example of it as far as opening an encrypted file through the command line but not through the package.
Any suggestions would be grealty appreciated.
Marshall
July 30, 2012 at 1:04 am
The Execute Process Task is the SSIS equivalent of executing a process through the command line.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 30, 2012 at 5:22 am
Thank you I began that process.
Now I do not see how to pass the password to an encrypted archive so that it loops through each archive and decompresses it.
I see where you can encrypt and zip a file but not the other way around.
July 30, 2012 at 5:45 am
You can find some 7zip command line examples here:
http://www.dotnetperls.com/7-zip-examples
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2012 at 12:56 am
setting password for extraction is similar to archiving 7z e -pPWD archive.zip
July 31, 2012 at 8:24 am
I believe I tried that and received an error.
Must be doing something incorrectly.
Let me try again.
Thank you
August 2, 2012 at 7:13 am
That definitely worked thank you.
I was able to pass it into the package.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply