Skip to Content

unzip file as well as decrypt the password

Hi All,

As per my requirement, I need to decrypt the password zip file and load into data into template table and Once loaded completed into a temp table, we should zip files and encrypt the password to that zip file. Can you please provide the script for zipping and unzip password protect?

for decrypt password zip file I have done below command script in the command line prompt

C:\Murali\Incoming>unzip -PWelcome123 Test.zip

it successfully unzips the files and loaded into a folder

using same script ( C:\Murali\Incoming>unzip -PWelcome123 Test.zip ), I have created a bat file with the name of Test.bat

and I called this bat file in BODS script using exec function, but I am getting below error.

4232 7412 JOB 7/2/2016 1:03:22 PM Optimizing job <FlatFiles>. 4232 7412 JOB 7/2/2016 1:03:22 PM Job <FlatFiles> is started. 4232 7412 PRINTFN 7/2/2016 1:03:22 PM 1: C:\Program Files (x86)\Business Objects\BusinessObjects Data Services\bin>C:\Murali\Incoming -PWelcome123 Test.zip 4232 7412 PRINTFN 7/2/2016 1:03:22 PM 1>unzip 'C:\Murali\Incoming' is not recognized as an internal or external command, operable program or batch file. 4232 7412 JOB 7/2/2016 1:03:22 PM Job <FlatFiles> is completed successfully.

Please help me for past 3 weeks I have been trying on this requirement, but no luck as of now

Thanks and Regards,

Murali

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 02, 2016 at 08:00 AM


    Sorry this is the one I called from BODS Script

    #Unzip the passpord protect zip file

    print( exec('C:\Murali\BatFiles\Test.bat','',8));

    Thanks and Regards,

    Murali

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.