This topic has not yet been rated - Rate this topic

FtpClientConnection Class

SQL Server 2012

Downloads and uploads data files and manages directories on servers. This class cannot be inherited.

System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.FtpClientConnection

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

public sealed class FtpClientConnection : DtsObject, 
	IDTSPersist

The FtpClientConnection type exposes the following members.

	Name	Description
	FtpClientConnection	Initializes a new instance of the FtpClientConnection class.

	Name	Description
	ChunkSize	Gets or sets the value that indicates the minimum number of bytes to retrieve from or send to the server during a File Transfer Protocol (FTP) read/write operation.
	Retries	Gets or sets the number of times the task attempts an operation. A value of 0 indicates that there is no limit on attempts.
	ServerName	Gets or sets the name of the File Transfer Protocol (FTP) server.
	ServerPassword	Sets the password for the server specified in the ServerName property. This property is write-only.
	ServerPort	Gets or sets the port number on the server.
	ServerUserName	Gets or sets the logon alias of the user.
	Timeout	Gets or sets a value that indicates how long to attempt the connection before timing out.
	UsePassiveMode	Gets or sets a Boolean that indicates whether the task sends and receives files in passive mode.

	Name	Description
	Close	Closes the FTP connection.
	Connect	Opens the connection to the server and returns a value that indicates the result of the connection.
	CreateRemoteDirectory	Creates a remote directory.
	DeleteFiles	Deletes the specified files from the File Transfer Protocol (FTP) server.
	DeleteRemoteDirectory	Deletes a remote directory.
	Equals	Determines whether two object instances are equal. (Inherited from DtsObject.)
	GetHashCode	Returns the hash code for this instance. (Inherited from DtsObject.)
	GetListing	Lists the names of directories and files in the specified folder or directory from the FTP server.
	GetType	(Inherited from Object.)
	GetWorkingDirectory	Gets the current working directory on the File Transfer Protocol (FTP) server.
	LoadFromXML	This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
	ReceiveFiles	Receives files from the File Transfer Protocol (FTP) server.
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
	SendFiles	Sends files to the File Transfer Protocol (FTP) server.
	SetWorkingDirectory	Sets the current working directory on the File Transfer Protocol (FTP) server.
	ToString	(Inherited from Object.)

For more information about the FTP task, see FTP Connection Manager.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions