SSIS (5) Data profiling database sniffing

The function of data profile is to look at the various files of a dataset (such as a table), such as the length statistics of each row, and the statistics of NULL values. The use is: a comprehensive understanding of the data within a data set.

1. New data profiling Control Flow task

2. New Connection

3. Specify the output location

4. Configure the output address

5. Select the DotA profiling request type

6. Perform Tasks

7. Viewing results with the Data Profile viewer

The deepening of the Data Profile viewer (deep digging, drill down) is actually showing specific details.

Support and conflicts about data profile dependencies:

For a dependent a->b, if a specific a value, such as 3, the corresponding B has a different value, such as {4,5,6,6,7}, then 3 in the end is the corresponding who, the system's strategy is: The default is more than the A->B support, the other is the conflict. Therefore, here a->b, then a A/b value (3,6) is valid, (3,4) (3,5), (3,7) is unreasonable.

SSIS (5) Data profiling database sniffing