Home Dashboard Directory Help
Search

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


Status: 

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


1
0
Sign in
to vote
Type: Suggestion
ID: 766664
Opened: 10/8/2012 8:31:51 PM
Access Restriction: Public
0
Workaround(s)
view

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 ...
Details
Sign in to post a comment.
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.
Sign in to post a workaround.