I am developing SSIS 2008 package. Amongst other things, it processes files located in a drop-off filesystem folder.
TASK:
After they are processed, files should be compressed and relocated to an archive folder.
QUESTION(s):
Does anyone know of a better solution, then to use an "Execute Process Task", calling a batch file which calls a 7-zip packer? Any freeware custom tasks?
Thanks in advance