Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)