FileSystemTask 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.
Runs commands against the file system. This class cannot be inherited.
public ref class FileSystemTask sealed : Microsoft::SqlServer::Dts::Runtime::Task, Microsoft::SqlServer::Dts::Runtime::IDTSBreakpointSite, Microsoft::SqlServer::Dts::Runtime::IDTSComponentPersist, Microsoft::SqlServer::Dts::Tasks::FileSystemTask::IDTSFileSystemTask
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.filesystemtask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FileSystemTask.Localized), SamplesTag="SsisFileSystemTask", TaskContact="File System Task;Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTaskUI, Microsoft.SqlServer.FileSystemTaskUI, Version=13.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("E5857CB6-FC91-45AD-8BB8-01E25D229BD6")]
public sealed class FileSystemTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Dts.Tasks.FileSystemTask.IDTSFileSystemTask
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.filesystemtask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FileSystemTask.Localized), SamplesTag="SsisFileSystemTask", TaskContact="File System Task;Microsoft Corporation; SQL Server 2017; © 2017 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTaskUI, Microsoft.SqlServer.FileSystemTaskUI, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("1D25A237-FC96-4421-ADDC-19BDD92E3139")]
public sealed class FileSystemTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Dts.Tasks.FileSystemTask.IDTSFileSystemTask
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.filesystemtask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FileSystemTask.Localized), SamplesTag="SsisFileSystemTask", TaskContact="File System Task;Microsoft Corporation; SQL Server 2019; © 2019 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTaskUI, Microsoft.SqlServer.FileSystemTaskUI, Version=15.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("9CF4BF80-E243-4A4B-90F1-998A6DEE35EC")]
public sealed class FileSystemTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Dts.Tasks.FileSystemTask.IDTSFileSystemTask
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.filesystemtask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FileSystemTask.Localized), SamplesTag="SsisFileSystemTask", TaskContact="File System Task;Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTaskUI, Microsoft.SqlServer.FileSystemTaskUI, Version=13.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("E5857CB6-FC91-45AD-8BB8-01E25D229BD6")>]
type FileSystemTask = class
inherit Task
interface IDTSFileSystemTask
interface IDTSBreakpointSite
interface IDTSSuspend
interface IDTSComponentPersist
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.filesystemtask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FileSystemTask.Localized), SamplesTag="SsisFileSystemTask", TaskContact="File System Task;Microsoft Corporation; SQL Server 2017; © 2017 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTaskUI, Microsoft.SqlServer.FileSystemTaskUI, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("1D25A237-FC96-4421-ADDC-19BDD92E3139")>]
type FileSystemTask = class
inherit Task
interface IDTSFileSystemTask
interface IDTSBreakpointSite
interface IDTSSuspend
interface IDTSComponentPersist
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.filesystemtask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.FileSystemTask.Localized), SamplesTag="SsisFileSystemTask", TaskContact="File System Task;Microsoft Corporation; SQL Server 2019; © 2019 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTaskUI, Microsoft.SqlServer.FileSystemTaskUI, Version=15.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("9CF4BF80-E243-4A4B-90F1-998A6DEE35EC")>]
type FileSystemTask = class
inherit Task
interface IDTSFileSystemTask
interface IDTSBreakpointSite
interface IDTSSuspend
interface IDTSComponentPersist
Public NotInheritable Class FileSystemTask
Inherits Task
Implements IDTSBreakpointSite, IDTSComponentPersist, IDTSFileSystemTask
- Inheritance
- Attributes
- Implements
Remarks
For information on the tasks that can be run with this task, see DTSFileSystemOperation.
Constructors
FileSystemTask() |
Initializes a new instance of the FileSystemTask class. |
Properties
Attributes |
Gets or sets the attributes to apply to the file or directory. |
DebugMode |
A Boolean indicating if a task should check if breakpoints are enabled. |
Destination |
Gets or sets the destination folder or file. |
ExecutionValue |
Returns the number of successful operations performed by the task. This field is read-only. |
IsDestinationPathVariable |
Gets or sets a Boolean that indicates whether Destination information is located in a package variable. |
IsSourcePathVariable |
Gets or sets a Boolean that indicates whether Source information is located in a package variable. |
Operation |
Gets or sets a value from the DTSFileSystemOperation enumeration that determines the type of operation to perform. |
OperationName |
Gets or sets the name of the task. |
OverwriteDestinationFile |
Gets or sets a Boolean that indicates whether the task will overwrite destination files. |
PreservedAttributes |
Gets or sets the Data Transformation Services preserved attributes. |
Source |
Gets or sets the source file or directory. If IsSourcePathVariable is set to true, gets or sets the package variable name representing the source file or directory. |
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. |