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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 766664 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/8/2012 8:31:51 PM
Access Restriction Public

Description

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 ...
Sign in to post a comment.
Posted by Mike Honey - Manga Solutions on 5/12/2015 at 6:51 PM
Please (continue to) ignore this item - I've switched to using the Excel Power Query Add-In for Data Profiling - it has many advantages over that SSIS component.
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.