Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Decrypt 7zip Expand / Collapse
Author
Message
Posted Thursday, July 26, 2012 3:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 25, 2015 12:12 PM
Points: 114, Visits: 364
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
Post #1336152
Posted Monday, July 30, 2012 1:04 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, February 5, 2016 2:07 PM
Points: 15,016, Visits: 12,988
The Execute Process Task is the SSIS equivalent of executing a process through the command line.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1337081
Posted Monday, July 30, 2012 5:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 25, 2015 12:12 PM
Points: 114, Visits: 364
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.
Post #1337180
Posted Monday, July 30, 2012 5:45 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, February 5, 2016 2:07 PM
Points: 15,016, Visits: 12,988
You can find some 7zip command line examples here:
http://www.dotnetperls.com/7-zip-examples




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1337192
Posted Tuesday, July 31, 2012 12:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 1, 2015 4:28 PM
Points: 7, Visits: 104
setting password for extraction is similar to archiving
7z e -pPWD archive.zip

Post #1337692
Posted Tuesday, July 31, 2012 8:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 25, 2015 12:12 PM
Points: 114, Visits: 364
I believe I tried that and received an error.
Must be doing something incorrectly.
Let me try again.

Thank you
Post #1337936
Posted Thursday, August 2, 2012 7:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 25, 2015 12:12 PM
Points: 114, Visits: 364
That definitely worked thank you.
I was able to pass it into the package.
Post #1339134
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse