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

How to create a command line for winzip command tool in SSIS that can be used to archive file. Expand / Collapse
Author
Message
Posted Thursday, April 10, 2008 12:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 7:54 PM
Points: 2, Visits: 14
Hello,

I would like to have codes and the illustration of steps to do in order to create a command line tools in SSIS which can be used to archive file.

Thanks,

Mark
Post #482799
Posted Friday, April 11, 2008 1:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 1:50 AM
Points: 58, Visits: 332
Hello,

create an 'execute process task'.
In Process / Executeable insert the execute (...winzip.exe )
In Expressions select the property Arguments. Here you insert
"-a -ex zipfile.zip examplefile".
A better approach is to work with variables for zipfile.zip and examplefile i.e.
"-a -ex " + @[user::zipfile] + " " + @[user::file]



Post #483477
Posted Tuesday, April 8, 2014 2:51 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 6:03 PM
Points: 40, Visits: 216
This expression will work with spaces in the folder location.

"-min -m -en " + "\"" + @[User::UnZipFileName] + ".ZIP \"" + "\"" + @[User::UnZipFileName] + "\""


The pain of Discipline is far better than the pain of Regret!
Post #1559708
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse