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 |
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
 Posted - 2006-08-18 : 04:21:21
|
| hiIs there any information where I can auto zip or rar once i have export it to a text file for download. the package is running on a schedule basis and the file is around 150MB and is to huge for download.Is there a way in the package where i can auto zip or auto rar it once it has been exported?Thanks |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-08-18 : 04:58:19
|
| Make it a multi-step dts whereby the 2nd step is a batch file calling winzip or similar licenced software, in unprompted mode. get this bit working outside of the DTS and then add it into the DTS. |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-08-18 : 07:56:34
|
| Look at, for example, commandline winzip: here's a sample of a commandline I am running in a cmd filewzzip.exe -a -rP d:\Target\ZipName%random%.zip d:\SourceFolder1\*.* d:\SourceFolder2\*.* d:\SourceFolder3\*.* d:\SourceFolder4\*.*-a = archive (default action)-r = recursive P = full path names (iirc)hth*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-08-18 : 07:57:37
|
| alternatively, you could create an SP to invoke the rar/wip commandline - I did this is SQL 2000, but I should warn that it involves using xp_cmdshell, which may be a secruity concern...*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
DTS to a text file and auto Zip or rar