17 Zip and UnZip files in SSIS

แชร์
ฝัง

ความคิดเห็น • 32

  • @sanchitasrivastava8065
    @sanchitasrivastava8065 ปีที่แล้ว

    Thanks for the tutorial. I want to use Winzip instead of 7zip as per requirement but i dont know why winzip is not working. Have you tried using winzip instead of 7zip. Thankyou!

  • @antoniolupen6138
    @antoniolupen6138 11 หลายเดือนก่อน

    I can compress/decompress files into an EXISTING folder but I failed when trying to create a folder and then compress/decompress files , all in the same sequence.

  • @aperxmim
    @aperxmim 2 ปีที่แล้ว

    not working for me, It created the zip file but it is empty, I get an error when I tried to open it.

  • @ramuurs7227
    @ramuurs7227 5 ปีที่แล้ว

    Why did you added a-t7z as arguments for zipping and e for unzipping? or can we use any other letters ? or they are predefined letters for zipping and unzipping?

    • @learnssis
      @learnssis  5 ปีที่แล้ว

      This how zipping and unzipping is done using 7 Zip.

  • @goussaaimad639
    @goussaaimad639 6 ปีที่แล้ว

    Hello, I need to decompress Files .gz by ssis my question is wich executable open source can i used ? and arguments ?

    • @learnssis
      @learnssis  6 ปีที่แล้ว

      Did you tried 7-Zip ?

    • @goussaaimad639
      @goussaaimad639 6 ปีที่แล้ว

      yes thanks working thnks ; executable 7zip and arguments is e "link"

  • @sudiptanath4103
    @sudiptanath4103 2 ปีที่แล้ว

    Hi. It's not zip the file. showing error The process exit code was "7" while the expected was "0". Could you please help me.

    • @learnssis
      @learnssis  2 ปีที่แล้ว

      Make sure you have set all the properties properly.

    • @tejaswinerella5223
      @tejaswinerella5223 ปีที่แล้ว

      Hi, @Sudiptanath4103 I'm also facing the same issue... The process exit code was "2" while the expected was "0". If you resolve this, can you please help me with this?

    • @dianbalde7642
      @dianbalde7642 10 หลายเดือนก่อน +1

      there's a space between the a and -t7z, use this a -t7z "

  • @MVinodKumar-tt1tu
    @MVinodKumar-tt1tu ปีที่แล้ว

    Hello Sir i downloaded 7Zip from chrome and i tried to zip a file and after completion of that when i try to extract the files it is saying there is no files in the zip file and first add the files before extract... Please help me in this sir

    • @learnssis
      @learnssis  ปีที่แล้ว

      Are you zipping the file using GUI or using the method shown in this video ?

    • @MVinodKumar-tt1tu
      @MVinodKumar-tt1tu ปีที่แล้ว

      @@learnssis I'm zipping the files using above method in the video sir(by Execute process task).

  • @parvanekhemati1015
    @parvanekhemati1015 ปีที่แล้ว

    Thank you so much that's greate

    • @learnssis
      @learnssis  ปีที่แล้ว

      You are most welcome.

  • @maxwelangye119
    @maxwelangye119 5 ปีที่แล้ว

    How do i loop the process to zip multiple files to multiple zip files

    • @learnssis
      @learnssis  5 ปีที่แล้ว

      For example if you want to zip 10 csv files to 10 zip files, then you can use For Each Loop Container and put the Execute Process Task inside the For each loop container. For each Loop Container will loop through each CSV file at a time and then you can pass the CSV file name to Execute Process Task, according to CSV file name, you can give a new name to Zip file as well. Thanks.

  • @rustik23
    @rustik23 7 ปีที่แล้ว

    Hi i am trying to unzip a *gz file? Is it possible without 3rd party software?

    • @learnssis
      @learnssis  7 ปีที่แล้ว

      Have you tried 7-Zip to unzip the *.gz file ? Actually I have used gzip.exe which is open source to zip the files for Clients but never tried unzipping them using command prompt.

    • @rustik23
      @rustik23 7 ปีที่แล้ว

      The thing is i need to do it without any 3rd party software,

    • @learnssis
      @learnssis  7 ปีที่แล้ว

      7 Zip is open source.

  • @ashick91
    @ashick91 3 ปีที่แล้ว

    can i not use winrar as .exe?

    • @learnssis
      @learnssis  3 ปีที่แล้ว

      You can use winrar as well but the parameters for compression and decompression will be different as they are totally different software.

  • @missarzomand
    @missarzomand 7 ปีที่แล้ว

    can i have as my mentor but i would like to communicate through email

  • @ashutoshsharma7658
    @ashutoshsharma7658 2 หลายเดือนก่อน

    I am successfully able to create zip file but during unzipping facing below error
    facing this error : In Executing "C:\Users\ashut\Downloads\a\a\x64\7za.exe"
    "e "C:\Users\ashut\Downloads
    ew\mynewzipfile.zip" " at "C:\Users\ashut\Downloads\a", The process exit code was "2" while the expected was "0".

    • @learnssis
      @learnssis  2 หลายเดือนก่อน

      Is this is a valid directory path ?
      "C:\Users\ashut\Downloads\a"

    • @ashutoshsharma7658
      @ashutoshsharma7658 2 หลายเดือนก่อน

      @@learnssis yes sir ..this path is valid

    • @ashutoshsharma7658
      @ashutoshsharma7658 2 หลายเดือนก่อน

      @@learnssis tried with path also "C:\Files\mynewzipfile.zip" also ...still same error