DTSProcessingTask Clase
Processes objects in a Microsoft SQL Server Analysis Services database.
Espacio de nombres: Microsoft.DataTransformationServices.Tasks.DTSProcessingTask
Ensamblado: Microsoft.SqlServer.ASTasks (en Microsoft.SqlServer.ASTasks.dll)
Sintaxis
'Declaración
<DtsTaskAttribute(LocalizationType := GetType(DTSProcessingTask), TaskType := "DTS90", _
UITypeName := "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", _
IconResource := "ProcessTaskIcon")> _
<GuidAttribute("BB85884C-3512-450f-9DB6-1AEDE8284283")> _
Public NotInheritable Class DTSProcessingTask _
Inherits ASTaskBase _
Implements IDTSComponentPersist
'Uso
Dim instance As DTSProcessingTask
[DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = "DTS90",
UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91",
IconResource = "ProcessTaskIcon")]
[GuidAttribute("BB85884C-3512-450f-9DB6-1AEDE8284283")]
public sealed class DTSProcessingTask : ASTaskBase,
IDTSComponentPersist
[DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = L"DTS90",
UITypeName = L"Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91",
IconResource = L"ProcessTaskIcon")]
[GuidAttribute(L"BB85884C-3512-450f-9DB6-1AEDE8284283")]
public ref class DTSProcessingTask sealed : public ASTaskBase,
IDTSComponentPersist
[<SealedAttribute>]
[<DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = "DTS90",
UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91",
IconResource = "ProcessTaskIcon")>]
[<GuidAttribute("BB85884C-3512-450f-9DB6-1AEDE8284283")>]
type DTSProcessingTask =
class
inherit ASTaskBase
interface IDTSComponentPersist
end
public final class DTSProcessingTask extends ASTaskBase implements IDTSComponentPersist
Ejemplos
The following code sample creates, configures, and executes a new DTSProcessingTask that processes the Targeted Mailing mining model in the Adventure Works DW sample database.
using Microsoft.SqlServer.Dts.Runtime;
using System.Reflection;
class Module1
{
public static void Main()
{
Package pkg = new Package();
string procCmd;
ConnectionManager asCM;
asCM = pkg.Connections.Add("MSOLAP100");
asCM.Name = "Analysis Services Connection Manager";
asCM.ConnectionString = "Data Source=<servername>;" +
"Initial Catalog=Adventure Works DW;Provider=MSOLAP;" +
"Integrated Security=SSPI;Impersonation Level=Impersonate;";
procCmd = "<Batch xmlns=\"https://schemas.microsoft.com/analysisservices/2003/engine\">" +
"<Parallel>" +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" " +
"xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +
"<Object>" +
"<DatabaseID>Adventure Works DW</DatabaseID>" +
"<MiningStructureID>Targeted Mailing</MiningStructureID>" +
"</Object>" +
"<Type>ProcessFull</Type>" +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation>" +
"</Process>" +
"</Parallel>" +
"</Batch>";
Executable exe = pkg.Executables.Add("Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask, " +
"Microsoft.SqlServer.ASTasks, Version=10.0.0.0, " +
"Culture=neutral, PublicKeyToken=89845dcd8080cc91");
TaskHost thTask = (TaskHost) exe;
{
thTask.Properties("ConnectionName").SetValue(thTask, "Analysis Services Connection Manager");
thTask.Properties("ProcessingCommands").SetValue(thTask, procCmd);
}
DTSExecResult valResults = pkg.Validate(pkg.Connections, pkg.Variables, null, null);
if (valResults==DTSExecResult.Success)
{
pkg.Execute();
}
}
}
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Reflection
Module Module1
Sub Main()
Dim pkg As New Package
Dim procCmd As String
Dim asCM As ConnectionManager
asCM = pkg.Connections.Add("MSOLAP100")
asCM.Name = "Analysis Services Connection Manager"
asCM.ConnectionString = "Data Source=<servername>;" & _
"Initial Catalog=Adventure Works DW;Provider=MSOLAP;" & _
"Integrated Security=SSPI;Impersonation Level=Impersonate;"
procCmd = "<Batch https://schemas.microsoft.com/analysisservices/2003/engine"">" & _
"<Parallel>" & _
"<Process xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" " & _
"xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"">" & _
"<Object>" & _
"<DatabaseID>Adventure Works DW</DatabaseID>" & _
"<MiningStructureID>Targeted Mailing</MiningStructureID>" & _
"</Object>" & _
"<Type>ProcessFull</Type>" & _
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation>" & _
"</Process>" & _
"</Parallel>" & _
"</Batch>"
Dim exe As Executable = pkg.Executables.Add( _
"Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask, " & _
"Microsoft.SqlServer.ASTasks, Version=10.0.0.0, " & _
"Culture=neutral, PublicKeyToken=89845dcd8080cc91")
Dim thTask As TaskHost = CType(exe, TaskHost)
With thTask
.Properties("ConnectionName").SetValue(thTask, _
"Analysis Services Connection Manager")
.Properties("ProcessingCommands").SetValue(thTask, procCmd)
End With
Dim valResults As DTSExecResult = pkg.Validate( _
pkg.Connections, pkg.Variables, Nothing, Nothing)
If valResults = DTSExecResult.Success Then
pkg.Execute()
End If
End Sub
End Module
Jerarquía de herencia
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime. . :: . .Task
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask. . :: . .ASTaskBase
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask..::..DTSProcessingTask
Seguridad para subprocesos
Todos los miembros públicos static (Shared en Visual Basic) de este tipo son seguros para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.