数据分析任务-自定义配置文件请求 [英] Data profiling Task - custom Profile Request

问题描述

是否可以为SSIS数据分析任务创建自定义配置文件请求？

Is there any option to create a custom Profile Request for SSIS Data Profiling Task?

目前在SSIS数据分析任务下有5个标准配置文件请求：

At the moment there are 5 standard profile requests under SSIS Data Profiling task:

1. 列空率配置文件请求


2. 列统计信息配置文件请求


3. 列长度分布概要文件请求


4. 列值分布概要文件请求


5. 候选键概要文件请求

1. Column Null Ratio Profile Request
2. Column Statistics Profile Request
3. Column Length Distribution Profile Request
4. Column Value Distribution Profile Request
5. Candidate Key Profile Request

我需要添加另一个（自定义项）以获取所有数值的汇总。

I need to add another one (Custom one) to get summary of all numeric values.

在此先感谢您的帮助。

推荐答案

基于此 Microsoft文档，SSIS数据分析任务只有5个主要配置文件（在您的问题上列出）并且没有添加自定义配置文件的选项。

Based on this Microsoft Documentation, SSIS Data profiling Task has only 5 main profiles (listed on your question) and there is no option to add a custom profile.

对于类似的r eason，我将创建一个 Execute SQL Task 来实现这一点，您可以使用所需的聚合函数和 ISNUMERIC 函数在where子句中：

For a similar reason, i will create an Execute SQL Task to achieve that, you can use the aggregate functions you need and ISNUMERIC function in the where clause :

SELECT MAX(CAST([Column] AS BIGINT)) -- Maximum value
       ,MIN(CAST([Column] AS BIGINT)) -- Minimum value
       ,COUNT(Column) -- Count values
       ,COUNT(DISTINCT [Column]) -- Count distinct values
       ,AVG(CAST([Column] AS BIGINT)) -- Average
       ,SUM(CAST([Column] AS BIGINT)) -- Sum
FROM TABLE
WHERE ISNUMERIC([Column]) = 1

这篇关于数据分析任务-自定义配置文件请求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！