Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-05-08 : 07:48:26
|
| I would like to create a command line tools in SSIS which can be used to archive files.I have 6 files in a dir and i like to zip them up and them move them to an archive dir. The 6 files all have the same name but the extension is different. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-08 : 08:16:53
|
Use pkzip. It allows command line switches.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-05-08 : 09:38:13
|
| We have winzip installed on the server. The part where am having a problem with is the multiple files do i use a for each look to get all the file and then zip them up with the process task in side of the for each loop ? |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-05-08 : 10:03:16
|
| I've used this before using Process Task but make sure you have this on the server -"The WinZip® Command Line Support Add-On is a FREE add-on for users of WinZip 11.2 Standard or Pro with a valid license. Before installing this add-on, please make sure you have WinZip 11.2 or later installed."http://www.winzip.com/prodpagecl.htm |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-05-12 : 10:01:05
|
| 7zip rocks.---http://www.ssisdude.blogspot.com/ |
|
|
|
|
|
|
Archive files using winzip in ssis