SSIS - Unzipping two times

  • Hi,

    I am new to SSIS. I am struck with unzipping with ssis, I have my files in my Folder and those are zipfiles some of them are .zip extension and some of them are .exe extension if I unzip these files some of them will give .txt files format and some of them are again giving .zip and .exe file format and these files are very large. I have used Execute process task to unzip the files, while using Execute process task i can only unzip .zip or .exe at a time i have used these argument in my Execute process task and i need to unzip it with 7zip

    " x "+ @[User::SourceFilepath] +"*.zip -o"+ @[User::DestinationFilePath] +" -y" if i use this argument i can only unzip the .zip file

    " x "+ @[User::SourceFilepath] +"*.exe -o"+ @[User::DestinationFilePath] +" -y" if i use this argument i can only unzip .exe format and these are again giving me some more .exe files and .zip files that i have to unzip

    can ony of the experts help me on this

  • Please do not cross-post. Direct replies here:

    http://www.sqlservercentral.com/Forums/Topic1448864-364-1.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply