Morning to EveryOne -

I need to read a folder on another server and if a file is there, delete it. Then I need to unzip another file.

How can I do this from a stored procedure in T-SQL ?

Thanks in advance,
Stoney

For unzip file create a stored procedure (you can also run this procedure as SQL server scheduled job)..


CREATE PROCEDURE procUnzipFile
AS
BEGIN
DECLARE @Command nvarchar(1000)
SET @Command = 'C:\MyFolder\unzipfile.bat'
EXEC xp_cmdshell @Command
END
GO


Your batch file (unzipfile.bat)
----------------------------------
c:\program files\winzip\wzunzip c:\myfolder\file.zip c:\myfolder
-------------------------------------

same thing is for delete create a batch file and call this batch file using xp_cmdshell in SQL server

Hey!! Thanks!!
Stoney