FTP_FolderCreate
Creates a new directory on a remote FTP Server
- Stored Procedure
- SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
EXEC SQLHTTP.net.FTP_FolderCreate @URL, [@UserName], [@Password], [@StatusCode], [@StatusDescription]
Name | Type | Description |
---|---|---|
@URL | nvarchar(4000) |
Required. FTP address starting with ftp:// |
@UserName | nvarchar(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 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
DECLARE @URL nvarchar(4000) DECLARE @StatusCode int DECLARE @StatusDescription nvarchar(MAX) SET @URL = 'ftp://speedtest.tele2.net/upload/MyNewFolder' EXEC SQLHTTP.net.FTP_FolderCreate @URL = @URL, @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT SELECT @StatusCode AS StatusCode, @StatusDescription AS StatusDescription |
1 2 3 4 5 |
StatusCode StatusDescription ------------ ------------------------------------ 550 550 Permission denied. |