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 |
|
m1
Starting Member
1 Post |
 Posted - 2002-05-06 : 06:41:07
|
| I want to make a compression (winzip) of a file created by DTS task! How can I do this????thanks |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-05-06 : 08:00:39
|
| HiYou have two ways of doing this. One is ugly, and probably a little slow, and definitely won't scale really well (but I'm guessing that is not a huge concern, you won't have lots of users hitting your DTS job at once). The other way is nicer, and will be quicker, but you will have to pay for a 3rd party component.Method 1Use pkzip (or possibly winzip) via command line. You can shell out these commands a couple of ways, one is using xp_cmdshell, or using a script task. You would do this just like the way you did zips in the old DOS days. I.E. (and this is from memory) pkzip zipname C:\files\*.*Method 2Use a COM object. I think Activefile does this (you can find it with Google). Or I use Xceed Zip (once again, Google will find it). Xceed is great, it is quick, does Exes (self extracting) as well. I have never had any problems with it.You can call the COM object from a script step in DTS, that will work well.They are your 2 basic methods. Both will do, it just depends on your requirements and constraints.Hope that helpsDamianEdited by - merkin on 05/06/2002 08:01:20 |
 |
|
|
|
|
|
winzip in dts