The output file might contain sensitive data about your database and the data that database contains. For suggestions about how to make this file more secure, see Access to Files Used by Packages.
Specify whether to save the data profile output to a file or a variable:
Save the profile output to a file in the location that is specified in a File connection manager.
You specify which File connection manager to use in the Destination option.
Save the profile output to a package variable.
You specify which package variable to use in the Destination option.
Specify which File connection manager or package variable contains the data profile output:
If the DestinationType option is set to FileConnection, the Destination option displays the available File connection managers. Select one of these connection managers, or select <New File connection> to create a new File connection manager.
If the DestinationType option is set to Variable, the Destination option displays the available package variables in the Destination list. Select one of these variables, or select <New Variable> to create a new variable.
Specify whether to overwrite the output file if it already exists. The default value is False. The value of this property is used only when the DestinationType option is set to FileConnection. When the DestinationType option is set to Variable, the task always overwrites the previous value of the variable.
If you try to run the Data Profiling task more than once without changing the output file name or changing the value of the OverwriteDestination property to True, the task fails with the message that the output file already exists.
Opens the Data Profile Viewer. The stand-alone Data Profile Viewer displays data profile output from the Data Profiling task. You can view the data profile output after you have run the Data Profiling task inside the Integration Services package and computed the data profiles.
You can also open the Data Profile Viewer by running the DataProfileViewer.exe in the folder, <drive>:\Program Files (x86) | Program Files\Microsoft SQL Server\110\DTS\Binn.