Export (0) Print
Expand All

DataProfilingTask Class

Profiles selected columns and column relationships in a data source to discover the structure of an unfamiliar data source, and to identify problems with the data.

Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.SqlServer.Dts.Tasks.DataProfilingTask.DataProfilingTask

Namespace:  Microsoft.SqlServer.Dts.Tasks.DataProfilingTask
Assembly:  Microsoft.SqlServer.DataProfilingTask (in Microsoft.SqlServer.DataProfilingTask.dll)

public sealed class DataProfilingTask : Task, 
	IDTSComponentPersist

The DataProfilingTask type exposes the following members.

  NameDescription
Public methodDataProfilingTaskInitializes a new instance of the DataProfilingTask class.
Top

  NameDescription
Public propertyDestinationGets or sets the File connection manager or the package variable that contains the XML output that the Data Profiling task generates.
Public propertyDestinationTypeGets or sets a value whether a File connection manager or a package variable contains the XML output the Data Profiling task generates.
Public propertyExecutionValueReturns a user-defined object. This field is read-only. (Inherited from Task.)
Public propertyOverwriteDestinationGets or sets a value that indicates whether the Data Profiling task should overwrite the output file if the file already exists.
Public propertyProfileInputXmlInfrastructure. Gets or sets an XML input of the DataProfilingTask.
Public propertyProfileRequestsGets the collection of profile requests that the Data Profiling task will compute.
Public propertyTimeoutGets or sets the number of seconds after which the Data Profiling task should time out and stop running.
Public propertyVersion*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only. (Inherited from Task.)
Top

  NameDescription
Public methodCanUpdate*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task.)
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodExecuteRuns the Data Profiling task. (Overrides Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Public methodGetConnectionIDGets a String containing the ID of the connection. (Inherited from Task.)
Public methodGetConnectionNameGets a String containing the name of the connection. (Inherited from Task.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodInitializeTaskInitializes the Data Profiling task. (Overrides Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)
Public methodLoadFromXMLLoads the definition of the task, in XML format, from the XML definition of the package.
Public methodSaveToXMLSaves the definition of the task, in XML format, into the XML definition of the package.
Public methodToString (Inherited from Object.)
Public methodUpdate*** Member deprecated; see Remarks. ***   This method updates the old package XML with the new package XML if CanUpdate is set to true. (Inherited from Task.)
Public methodValidateDetermines whether the Data Profiling task is correctly configured. (Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)
Top

The DataProfilingTask class is the main class in the Microsoft.SqlServer.Dts.Tasks.DataProfilingTask namespace. This class represents the Integration Services Data Profiling task, which can be used to profile and discover the structure of an unfamiliar data source, and to identify problems with the data.

For more information about the Data Profiling task, see the following topics:

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft