FTP_FileDelete

Deletes an existing file on a remote FTP Server

Stored Procedure
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

EXEC SQLHTTP.net.FTP_FileDelete @URL, [@UserName], [@Password], [@StatusCode], [@StatusDescription]

Arguments:

Name	Type	Description
@URL	nvarchar(4000)	Required. FTP address that includes the file to delete.
@UserName	nvrchar(200)	Optional. Leave blank (NULL) for anonymous connections
@Password	nvarchar(200)	Optional. Leave blank (NULL) for anonymous connections
@StatusCode	int	Optional. Output Parameter. Numeric status of the response.
@StatusDescription	nvarchar(MAX)	Optional. Output Parameter. Status Description returned with the response.



Sample Usage:


DECLARE @URL nvarchar(4000)
DECLARE @StatusCode int
DECLARE @StatusDescription nvarchar(MAX)

SET @URL = 'ftp://speedtest.tele2.net/upload/100MB.zip'

EXEC SQLHTTP.net.FTP_FileDelete 	@URL = @URL,
					@StatusCode = @StatusCode OUTPUT,
					@StatusDescription = @StatusDescription OUTPUT

SELECT  @StatusCode AS StatusCode,
	@StatusDescription AS StatusDescription

DECLARE @URL nvarchar(4000)

DECLARE @StatusCode int

DECLARE @StatusDescription nvarchar(MAX)

SET @URL = 'ftp://speedtest.tele2.net/upload/100MB.zip'

EXEC SQLHTTP.net.FTP_FileDelete @URL = @URL,

@StatusCode = @StatusCode OUTPUT,

@StatusDescription = @StatusDescription OUTPUT

SELECT @StatusCode AS StatusCode,

@StatusDescription AS StatusDescription

StatusCode StatusDescription

------------ ------------------------------------

550 550 Permission denied.



FTP_FileDelete

Featured API Wrapper Code / SQL Server