Search

SSIS Data Profiling Task Destination defaults by Mike Honey - Manga Solutions

Active

1
0
Sign in
to vote
Type: Suggestion
ID: 766663
Opened: 10/8/2012 8:22:08 PM
Access Restriction: Public
0
Workaround(s)
When you add a Data Profiling Task to an SSIS package Control Flow, the defaults for the Destination properties seem counterintuitive.

Typically for the Destination property you would create a new File Connection. The Usage Type defaults to: "Existing file" - surely "Create file" would be more common?

Also the OverwriteDestination property defaults to False - surely True would be more common?
Details (expand)

Product Language

English

Category

Integration Services (DTS)

Proposed Solution

When you create a new File Connection, the Usage Type should default to: "Create file". A generated default file name would be nice too e.g. use the Task Name.

The OverwriteDestination property should default to True.

Primary Benefit

Faster Development

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.