Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:10 PM
Points: 98, Visits: 297
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:03 PM
Points: 13,606, Visits: 10,489
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 LessThanDot.

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

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:10 PM
Points: 98, Visits: 297
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:03 PM
Points: 13,606, Visits: 10,489
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 LessThanDot.

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: 2 days ago @ 4:57 AM
Points: 7, Visits: 83
setting password for extraction is similar to archiving
7z e -pPWD archive.zip

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

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:10 PM
Points: 98, Visits: 297
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:10 PM
Points: 98, Visits: 297
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