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 - Unzipping two times Expand / Collapse
Author
Message
Posted Thursday, May 02, 2013 9:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 10, 2014 10:37 AM
Points: 25, Visits: 325

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
Post #1448864
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse