DTSProcessingTask Class
Processes objects in a Microsoft SQL Server Analysis Services database.
Namespace: Microsoft.DataTransformationServices.Tasks.DTSProcessingTask
Assembly: Microsoft.SqlServer.ASTasks (in Microsoft.SqlServer.ASTasks.dll)
Syntax
'Declaration
<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
'Usage
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
Examples
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
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.Task
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASTaskBase
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.