• Article

FtpClientConnection.SendFiles Method

Sends files to the File Transfer Protocol (FTP) server.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

'Declaration
Public Sub SendFiles ( _
    localFileNames As String(), _
    remotePath As String, _
    overwrite As Boolean, _
    isTransferAscii As Boolean _
)
'Usage
Dim instance As FtpClientConnection
Dim localFileNames As String()
Dim remotePath As String
Dim overwrite As Boolean
Dim isTransferAscii As Boolean

instance.SendFiles(localFileNames, remotePath, _
    overwrite, isTransferAscii)

public void SendFiles(
    string[] localFileNames,
    string remotePath,
    bool overwrite,
    bool isTransferAscii
)

public:
void SendFiles(
    array<String^>^ localFileNames, 
    String^ remotePath, 
    bool overwrite, 
    bool isTransferAscii
)

member SendFiles : 
        localFileNames:string[] * 
        remotePath:string * 
        overwrite:bool * 
        isTransferAscii:bool -> unit 

public function SendFiles(
    localFileNames : String[], 
    remotePath : String, 
    overwrite : boolean, 
    isTransferAscii : boolean
)

Parameters

  • localFileNames
    Type: array<System.String[]
    The files on the FTP server to send.
  • remotePath
    Type: System.String
    The remote path where the files are located.
  • overwrite
    Type: System.Boolean
    Specifies whether to overwrite the files, if the files already exist on the remote computer. A value of true indicates that the task will overwrite existing files.
  • isTransferAscii
    Type: System.Boolean
    Specifies if files should be sent in ASCII mode. A value of true indicates that the files should be sent in ASCII mode.

Examples

The following code example shows how to use the SendFiles method.

  Package pkg = new Package();
  Connections conns = pkg.Connections;
  ConnectionManager cm = conns.Add("FTP");
  //...
  FtpClientConnection myftpClientConn = new FtpClientConnection(cm);
  String[] localFileNames = { "myTestFile", "myFTPFile" };
  String remotePath = @"\\myserver\myFolder";
  myftpClientConn.SendFiles(localFileNames, remotePath, true, false);

  Dim pkg As New Package()
  Dim conns As Connections = pkg.Connections
  Dim cm As ConnectionManager = conns.Add("FTP")
  '...
  Dim myftpClientConn As New FtpClientConnection(cm)
  Dim localFileNames() As String = {"myTestFile", "myFTPFile"}
  Dim remotePath As String = "\\myserver\myFolder"
  myftpClientConn.SendFiles(localFileNames, remotePath, True, False)