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.
Assembly: Microsoft.SqlServer.DataProfilingTask (in Microsoft.SqlServer.DataProfilingTask.dll)
Microsoft.SqlServer.Dts.Runtime::DtsObject
Microsoft.SqlServer.Dts.Runtime::Task
Microsoft.SqlServer.Dts.Tasks.DataProfilingTask::DataProfilingTask
| Name | Description | |
|---|---|---|
![]() | DataProfilingTask() | Initializes a new instance of the DataProfilingTask class. |
| Name | Description | |
|---|---|---|
![]() | Destination | Gets or sets the File connection manager or the package variable that contains the XML output that the Data Profiling task generates. |
![]() | DestinationType | Gets or sets a value whether a File connection manager or a package variable contains the XML output the Data Profiling task generates. |
![]() | ExecutionValue | Returns a user-defined object. This field is read-only. (Inherited from Task.) |
![]() | OverwriteDestination | Gets or sets a value that indicates whether the Data Profiling task should overwrite the output file if the file already exists. |
![]() | ProfileInputXml | This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets an XML input of the DataProfilingTask. |
![]() | ProfileRequests | Gets the collection of profile requests that the Data Profiling task will compute. |
![]() | TargetServerVersion | (Inherited from Task.) |
![]() | Timeout | Gets or sets the number of seconds after which the Data Profiling task should time out and stop running. |
![]() | Version | *** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only.(Inherited from Task.) |
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.

