DTSFileSystemOperation Numaralandırması
Dosya sistemi işlemi gerçekleştirmek için gösterir.
Ad Alanı: Microsoft.SqlServer.Dts.Tasks.FileSystemTask
Derleme: Microsoft.SqlServer.FileSystemTask (Microsoft.SqlServer.FileSystemTask içinde.dll)
Sözdizimi
'Bildirim
Public Enumeration DTSFileSystemOperation
'Kullanım
Dim instance As DTSFileSystemOperation
public enum DTSFileSystemOperation
public enum class DTSFileSystemOperation
type DTSFileSystemOperation
public enum DTSFileSystemOperation
Üyeler
Üye adı | Açıklama | |
---|---|---|
CopyFile | FileSystemTask Kopyalar bir dosya.Her ikisi de IsDestinationPathVariable ve IsSourcePathVariable olması küme. | |
MoveFile | FileSystemTask Gider dosyası.Her ikisi de IsDestinationPathVariable ve IsSourcePathVariable olması küme. | |
DeleteFile | FileSystemTask Sildiğinizde bir dosya.IsSourcePathVariable küme olması gerekir. | |
RenameFile | FileSystemTask Yeniden adlandırmak dosya.Her ikisi de IsDestinationPathVariable ve IsSourcePathVariable olması küme. | |
SetAttributes | FileSystemTask küme nitelikleriyle bir dosya veya dizin.Her ikisi de IsDestinationPathVariable ve IsSourcePathVariable olması küme. | |
CreateDirectory | FileSystemTask Oluşturacaktır dizin.IsSourcePathVariable küme olması gerekir. | |
CopyDirectory | FileSystemTask Kopyalar dizin.Her ikisi de IsDestinationPathVariable ve IsSourcePathVariable olması küme. | |
MoveDirectory | FileSystemTask Gider dizin.Her ikisi de IsDestinationPathVariable ve IsSourcePathVariable olması küme. | |
DeleteDirectory | FileSystemTask Sildiğinizde bir dizin.IsSourcePathVariable küme olması gerekir. | |
DeleteDirectoryContent | FileSystemTask Sildiğinizde içeriğini bir dizine.IsSourcePathVariable küme olması gerekir. |
Örnekler
Aşağıdaki kod örneği oluşturur bir FileSystemTask olarak bir Executable paket.FileSystemTask Kopyalar bir sınama klasörü içeren iki alt klasörler ve .txt dosyası, başka bir klasör.Klasör ve alt klasörleri çünkü kopyalanan eylem tarafından belirtildiği şekilde gerçekleştirmek için Operation özellik küme CopyDirectory.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.FileSystemTask;
namespace FileSystemTask_API
{
class Program
{
static void Main(string[] args)
{
String sourceDir = @"C:\TestFolder";
String destDir = @"C:\MyNewTestFolder";
Package pkg = new Package();
Executable exec1 = pkg.Executables.Add("STOCK:FileSystemTask");
TaskHost th = exec1 as TaskHost;
// Show how to set properties using the TaskHost Properties.
// Set the properties to copy an existing folder, which contains two subfolders
// and a .txt file, to another existing folder on the C:\ drive.
// The source or destination files are not in a variable, so set
// IsSourcePathVariable and IsDestinationPathVariable to false.
th.Properties["IsSourcePathVariable"].SetValue(th, false);
th.Properties["IsDestinationPathVariable"].SetValue(th, false);
// Create the File connection manager for the source.
ConnectionManager cm = pkg.Connections.Add("FILE");
cm.Name = "The FILE connection manager";
cm.ConnectionString = sourceDir;
cm.Properties["FileUsageType"].SetValue(cm, DTSFileConnectionUsageType.FolderExists);
// Create the File connection manager for the destination.
ConnectionManager cmdest = pkg.Connections.Add("FILE");
cmdest.Name = "The destination FILE connection manager";
cmdest.ConnectionString = destDir;
cmdest.Properties["FileUsageType"].SetValue(cmdest, DTSFileConnectionUsageType.FolderExists);
// Set the source property and destination properties
// for the task.
th.Properties["Source"].SetValue(th, cm.Name);
th.Properties["Destination"].SetValue(th, cmdest.Name);
// The operation to perform is to copy all the files and
// subfolders in a folder.
// Do not overwrite the destination information
// if it exists.
th.Properties["Operation"].SetValue(th, DTSFileSystemOperation.CopyDirectory);
th.Properties["OperationName"].SetValue(th, "Copy TestFolder");
th.Properties["OverwriteDestinationFile"].SetValue(th, false);
// Set the attribute of the folder to be read-only.
th.Properties["Attributes"].SetValue(th, DTSFileSystemAttributes.ReadOnly);
// Multiple attributes can be set. The next line of code,
// commented out, shows how to do that.
//th.Properties["Attributes"].SetValue(th, DTSFileSystemAttributes.ReadOnly | DTSFileSystemAttributes.Hidden);
// Run the task and copy the folder.
DTSExecResult result = pkg.Execute();
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.FileSystemTask
Namespace FileSystemTask_API
Class Program
Shared Sub Main(ByVal args() As String)
Dim sourceDir As String = "C:\TestFolder"
Dim destDir As String = "C:\MyNewTestFolder"
Dim pkg As Package = New Package()
Dim exec1 As Executable = pkg.Executables.Add("STOCK:FileSystemTask")
Dim th As TaskHost = exec1 as TaskHost
' Show how to set properties using the TaskHost Properties.
' Set the properties to copy an existing folder, which contains two subfolders
' and a .txt file, to another existing folder on the C:\ drive.
' The source or destination files are not in a variable, so set
' IsSourcePathVariable and IsDestinationPathVariable to false.
th.Properties("IsSourcePathVariable").SetValue(th, False)
th.Properties("IsDestinationPathVariable").SetValue(th, False)
' Create the File connection manager for the source.
Dim cm As ConnectionManager = pkg.Connections.Add("FILE")
cm.Name = "The FILE connection manager"
cm.ConnectionString = sourceDir
cm.Properties("FileUsageType").SetValue(cm, DTSFileConnectionUsageType.FolderExists)
' Create the File connection manager for the destination.
Dim cmdest As ConnectionManager = pkg.Connections.Add("FILE")
cmdest.Name = "The destination FILE connection manager"
cmdest.ConnectionString = destDir
cmdest.Properties("FileUsageType").SetValue(cmdest, DTSFileConnectionUsageType.FolderExists)
' Set the source property and destination properties
' for the task.
th.Properties("Source").SetValue(th, cm.Name)
th.Properties("Destination").SetValue(th, cmdest.Name)
' The operation to perform is to copy all the files and
' subfolders in a folder.
' Do not overwrite the destination information
' if it exists.
th.Properties("Operation").SetValue(th, DTSFileSystemOperation.CopyDirectory)
th.Properties("OperationName").SetValue(th, "Copy TestFolder")
th.Properties("OverwriteDestinationFile").SetValue(th, False)
' Set the attribute of the folder to be read-only.
th.Properties("Attributes").SetValue(th, DTSFileSystemAttributes.ReadOnly)
' Multiple attributes can be set. The next line of code,
' commented out, shows how to do that.
'th.Properties["Attributes"].SetValue(th, DTSFileSystemAttributes.ReadOnly | DTSFileSystemAttributes.Hidden);
' Run the task and copy the folder.
Dim result As DTSExecResult = pkg.Execute()
End Sub
End Class
End Namespace