Move File to Another Directory on Server

Moves a file from one directory to another. This is accomplished by renaming the file using a filepath that includes the directory.

Download 32-bit Chilkat FTP2 ActiveX (.msi)

Download All 32-bit Chilkat ActiveX Components (.zip)

Download All 64-bit Chilkat ActiveX Components (.zip)

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @ftp int
    EXEC @hr = sp_OACreate 'Chilkat.Ftp2', @ftp OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    --  Any string unlocks the component for the 1st 30-days.
    EXEC sp_OAMethod @ftp, 'UnlockComponent', @success OUT, 'Anything for 30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    EXEC sp_OASetProperty @ftp, 'Hostname', 'ftp.myFtpServer123.com'
    EXEC sp_OASetProperty @ftp, 'Username', '***'
    EXEC sp_OASetProperty @ftp, 'Password', '***'

    --  Connect and login to the FTP server.
    EXEC sp_OAMethod @ftp, 'Connect', @success OUT
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    --  Rename the remote file (or directory)
    DECLARE @existingFilepath nvarchar(4000)

    SELECT @existingFilepath = 'dirA/hello.txt'
    DECLARE @newFilepath nvarchar(4000)

    SELECT @newFilepath = 'dirB/hello.txt'
    EXEC sp_OAMethod @ftp, 'RenameRemoteFile', @success OUT, @existingFilepath, @newFilepath
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @ftp, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    EXEC sp_OAMethod @ftp, 'Disconnect', NULL
END
GO