DataProfileDestinationType Enumeration

Specifies whether the Data Profiling task saves its XML output to a file or a package variable.

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

public enum DataProfileDestinationType

Member nameDescription
FileConnectionSaves the XML output in the file that is specified in a File connection manager.
VariableSaves the XML output in a package variable.

Select the DataProfileDestinationType property on the General page of the Data Profiling Task Editor.

Community Additions