FtpTask Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Downloads and uploads data files and manages directories on servers. This class cannot be inherited.
public ref class FtpTask sealed : Microsoft::SqlServer::Dts::Runtime::Task, Microsoft::SqlServer::Dts::Runtime::IDTSBreakpointSite, Microsoft::SqlServer::Dts::Runtime::IDTSComponentPersist, Microsoft::SqlServer::Dts::Tasks::FtpTask::IDTSFTPTask
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.ftptask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FtpTask.Localized), SamplesTag="SsisFtpTask", TaskContact="FTP Task; Microsoft Corporation; SQL Server 2016; (c) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FtpTask.FTPTaskUI, Microsoft.SqlServer.FTPTaskUI, Version=13.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("613C335B-A72A-4962-A221-510FF6EFE9B5")]
public sealed class FtpTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Dts.Tasks.FtpTask.IDTSFTPTask
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.ftptask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FtpTask.Localized), SamplesTag="SsisFtpTask", TaskContact="FTP Task; Microsoft Corporation; SQL Server 2017; (c) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FtpTask.FTPTaskUI, Microsoft.SqlServer.FTPTaskUI, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("546237B3-0903-4728-B757-30757AF6E1A1")]
public sealed class FtpTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Dts.Tasks.FtpTask.IDTSFTPTask
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.ftptask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FtpTask.Localized), SamplesTag="SsisFtpTask", TaskContact="FTP Task; Microsoft Corporation; SQL Server 2019; (c) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FtpTask.FTPTaskUI, Microsoft.SqlServer.FTPTaskUI, Version=15.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("053C6358-D2FA-4D81-B0C3-3B25BB2680C4")]
public sealed class FtpTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Dts.Tasks.FtpTask.IDTSFTPTask
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.ftptask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FtpTask.Localized), SamplesTag="SsisFtpTask", TaskContact="FTP Task; Microsoft Corporation; SQL Server 2016; (c) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FtpTask.FTPTaskUI, Microsoft.SqlServer.FTPTaskUI, Version=13.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("613C335B-A72A-4962-A221-510FF6EFE9B5")>]
type FtpTask = class
inherit Task
interface IDTSFTPTask
interface IDTSComponentPersist
interface IDTSBreakpointSite
interface IDTSSuspend
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.ftptask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FtpTask.Localized), SamplesTag="SsisFtpTask", TaskContact="FTP Task; Microsoft Corporation; SQL Server 2017; (c) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FtpTask.FTPTaskUI, Microsoft.SqlServer.FTPTaskUI, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("546237B3-0903-4728-B757-30757AF6E1A1")>]
type FtpTask = class
inherit Task
interface IDTSFTPTask
interface IDTSComponentPersist
interface IDTSBreakpointSite
interface IDTSSuspend
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.ftptask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FtpTask.Localized), SamplesTag="SsisFtpTask", TaskContact="FTP Task; Microsoft Corporation; SQL Server 2019; (c) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FtpTask.FTPTaskUI, Microsoft.SqlServer.FTPTaskUI, Version=15.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("053C6358-D2FA-4D81-B0C3-3B25BB2680C4")>]
type FtpTask = class
inherit Task
interface IDTSFTPTask
interface IDTSComponentPersist
interface IDTSBreakpointSite
interface IDTSSuspend
Public NotInheritable Class FtpTask
Inherits Task
Implements IDTSBreakpointSite, IDTSComponentPersist, IDTSFTPTask
- Inheritance
- Attributes
- Implements
Constructors
FtpTask() |
Initializes a new instance of the FtpTask class. |
Properties
Connection |
Gets or sets the connection name of the FTP connection manager used by the task. |
DebugMode |
Indicates whether a task should check if breakpoints are enabled. |
ExecutionValue |
Returns a user-defined object. This property is read-only. |
IsLocalPathVariable |
Indicates whether the local path is stored in a variable or a FILE connection manager. |
IsRemotePathVariable |
Indicates whether the remote path is stored in a variable. |
IsTransferTypeASCII |
Indicates whether files transferred to and from the remote FTP server should be transferred in ASCII mode. |
LocalPath |
Gets or sets the local path to use. The local path can refer to a FILE connection manager or a variable name. |
Operation |
Gets or sets a value from the DTSFTPOp enumeration that indicates the FTP operation to perform. |
OperationName |
Gets or sets a unique name for the File Transfer Protocol (FTP) task. |
OverwriteDestination |
Specifies whether a file at the destination can be overwritten. |
RemotePath |
Gets or sets the remote path to use. |
StopOnOperationFailure |
Indicates whether the File Transfer Protocol (FTP) task terminates when the FTP operation fails. |
SuspendRequired |
Gets or sets a Boolean that indicates if tasks should suspend when they encounter a breakpoint. This value is set by the runtime engine for tasks and containers when a breakpoint is encountered. |
TargetServerVersion | (Inherited from Task) |
Version |
*** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only. (Inherited from Task) |
Methods
AcceptBreakpointManager(BreakpointManager) |
Passes a BreakpointManager to the task. This method is called by the runtime and is not used in code. |
CanUpdate(String) |
*** Member deprecated; see Remarks. *** A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task) |
Equals(Object) |
Determines whether two object instances are equal. (Inherited from DtsObject) |
Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object) |
Runs the task. |
GetConnectionID(Connections, String) |
Gets a String containing the ID of the connection. (Inherited from Task) |
GetConnectionName(Connections, String) |
Gets a String containing the name of the connection. (Inherited from Task) |
GetHashCode() |
Returns the hash code for this instance. (Inherited from DtsObject) |
InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker) |
Initializes the properties associated with the task. This method is called by the runtime and is not used in code. |
LoadFromXML(XmlElement, IDTSInfoEvents) |
This method is not callable by your application code. To load a package that is saved as .xml to the hard drive, use the LoadPackage(String, IDTSEvents) method. |
ResumeExecution() |
Resumes execution of the task after pausing. The task or container is resumed by the runtime engine. |
SaveToXML(XmlDocument, IDTSInfoEvents) |
This method is not callable by your application code. To save a package as .xml, use the SaveToXml(String, Package, IDTSEvents) method. |
SuspendExecution() |
Indicates that the executable needs to suspend. This method is called by the runtime engine. |
Update(String) |
*** Member deprecated; see Remarks. *** This method updates the old package XML with the new package XML if CanUpdate(String) is set to true. (Inherited from Task) |
Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging) |
Verifies that the task is properly configured. |