Need your help here.
As we can have WinRAR.exe file and that we can execute fro procedure that will zip the source file.
We will require some specific format to execute the file from SQL Server "SQL Command".
Procedure should have parameter as @SrcFile ,@DestFile and that will ZIP the Source file to DestinationFile . as specified location in Parameter.
Create Proc spZipFile
@SrcFile varchar(1000), -- Location with File name
@DestFile varchar(1000) --Location eith Filename.zip
Thanks in Advance