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 Wednesday, May 1, 2013 2:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 14, 2014 12:25 PM
Points: 25, Visits: 333
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 #1448612
Posted Friday, May 3, 2013 10:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 7,080, Visits: 12,571
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
Post #1449288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse