I have this DTS that creates 5 files. The last step on the DTS is anActiveX task that moves the files to a certain folder. Bun?t now what I really need to do is zip the file and leave it on the server.
This DTS is executed by a job on the SQL Server, and the files are created on a network share with access to the SQLServer user that executes the job.
I've been trying to find out information on how to zip the folder and I've come up with two options:
1. install winzip on the server and run winzip32.exe passing arguments to it.
2. use the standard zipfldr.dll that comes with Windows to do the job.
Number one is out of my reach since IT department don't want the software installed, I have to stick with number 2.
Now I've read that using rundll32.exe I can run the dll as an exe, but I need the entry point to the dll wich I cannot find besides the RouteTheCall %L, which actually opens an explorer window with the folder or zip file I pass to it as an argument.
Does anyone know if this is possible either using rundll32.exe or automating the task through an AttiveX task?
TIA.
I would really like to find the answer to this question as well but, I don't see any replies and I noticed that this posting is 8 months old. I also could not find any information on the web as of yet. If I find anything I will respond to this post.
Steve
|||I recently think of the 2nd method. But it's too difficult. If you find how to use the zipfldr.dll .Please tell me. Thanks a lot. And , I will tell me if I get a clear using.|||I programming to compress the data. I want to call am usable zipfldr.dll with C#.NET programming, eager to know that must use which order in the calling uses. please tell me at jenkarn_7@.hotmail.com, thanks.
|||I just searched for "zip file" on msdn... http://blogs.msdn.com/dotnetinterop/archive/2006/04/05/567402.aspx
|||Easiest method of compressing files is to use rar.exe (WinRar CLI).rar -a C:\FilesToCompress\*.xxx C:\MyCompressedfile.rar
Can run that through a CLI in SSIS and DTS.
No comments:
Post a Comment