SSIS Data Profiling wizard to generate multiple tasks by Mike Honey - Manga Solutions

Resolved

as Won't Fix Help for as Won't Fix

Type:	Suggestion
ID:	766664
Opened:	10/8/2012 8:31:51 PM
Access Restriction:	Public

Workaround(s)

view

Often I need to create multiple Data Profiling tasks with similar properties for multiple source tables, e.g. all the Dimension and Fact tables in the Datamart for a particular environment. The Quick Profile settings are common to each table. The output File Connection names and Destination file names follow a pattern which includes the table name.

This is a repetitive, fiddly task best done by a computer, not a human ...

Details (expand)

English

Integration Services (DTS)

Add a "Data Profiling wizard" to generate multiple Data Profiling tasks with similar properties for multiple source tables.

First the user would choose from the tables/views in a source connection. Each table would be output to a new File Connection which could use the table name as the File Connection name and Destination. Common properties would be the Quick Profile settings or similar, applied to each table. The end result would be a set of new Data Profiling tasks (one per selected table/view), added to the SSIS package Control Flow.

Faster Development

Increased use of the valuable Data Profiling methods/tools to improve data understanding and quality.

0 attachments

Posted by Microsoft on 1/18/2013 at 1:17 AM

Hi, thank you for your feedback. We have investigated the need to add a Data Profiling wizard. The scope and impact of supporting this does not meet our criteria. You can consider programmatically generating SSIS packages that contain multiple Data Profiling Tasks.

Microsoft