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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2003-06-23 : 11:03:17
|
| Hi Folks,I have a DTS package which processes text files and puts them in a archive folder. I would like to have the files zipped once it gets into the archive folder. Is there a way to do this in DTS.RamdasRamdas NarayananSQL Server DBA |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-06-23 : 11:18:42
|
| If all you're after is compression then I would recommend doing that through the operating system by electing to have the root folder compressed.SQL Server does not create .zip files natively, but you can certainly call an executable from it like winzip.exe to do it. If you want one file but are not picky about method then you might also try cabarc.exe which is the OS executable for creating .cab files.Jonathan{0} |
 |
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2003-06-23 : 12:37:54
|
| Hi Folks,Thank you.Ramdas NarayananSQL Server DBA |
|
|
|
|
|
|
Zipping Files Using DTS