Sunday, April 8, 2018

How to Zip the files in SSIS 2012

How to Zip the files in SSIS 2012

  • We are going to use the desktop as location to doing these operation.
  • First step is to create one folder in the desktop as “SampleFolder”
  • Create 2 sample text files in the folder (Give whatever name as your wish)
  • Now in the SSIS package drag and drop the Execute Process Task
  • In the Execute process Task properties give three properties as like below
  • Executable : C:\Program Files (x86)\WinRAR\WinRAR.exe (configure the WINRAR installed path)
  • Arguments: A SamplesZip3 *.txt
                A indicates the Archives folder
                Give space
                Give the Zip Folder Name as you like
                Give Space
                Put *
                .txt
       Note: - In Argument property is the main place to give the file format that Argument should                            write as it is given above.

  • Working Directory :- C:\Users\LOKESH\Desktop\ SampleFolder
Please follow the below image


Regards,
LOKESH ANNAM
9492179390

1 comment:

  1. Thank you so much for providing this solution.I guess many people still have problem in dealing and zipping files in a proper up-to-date format.

    SSIS Postgresql Write

    ReplyDelete