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 |
|
Ruchi_Khushi
Starting Member
1 Post |
 Posted - 2008-03-12 : 05:43:40
|
| hi,i have designed DTS packages, I have a script component that picks up the 'Path' of a file stored.The Path is a column in database and that obtained from OLEDB source.now i need to zip the files in the path given above and than store it in some location. How do I do that? |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2008-03-13 : 22:20:58
|
| You'll need a Zip utility that can be run entirely from command line or batch file; the full (paid) version of Winzip will do this, as will PKzip.---------------------Tim Mitchellwww.BucketOfBits.com |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-14 : 09:55:42
|
| I use 7Zip on some of my servers and it works like a charm.You feed a variable with the value from your table with the path and pass that to a Execute Process Task component, the Execute Process Task component will execute the 7Zip executable (or whatever compression software you use) and execute your decompression command.You'll need to make use of Expression to build your executions string since it can change based on the values from your table. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-14 : 22:47:28
|
| Yes, 7zip even works on 64-bit machine. |
|
|
|
|
|
|
How do i use Execute Process task to zip a file/fo