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.

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


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.