Home Dashboard Directory Help
Search

[SSIS] DTExec Validate doesn't log SSIS.Pipeline validation phase performance warnings by Luca Zavarella


Status: 

Active


19
0
Sign in
to vote
Type: Bug
ID: 788331
Opened: 5/21/2013 12:03:05 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description


Suppose having a package that doesn't use all the columns defined in its Data Flow source component. It seems impossible to get warnings such as:

"The output column "A" (aa) on output "XXX" (xx) and component "YYY" (yy) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance."

using the command:

DTExec /File "<full_path_package_name>" /Validate /Reporting EW


I suppose DTExec validation doesn't throw out SSIS.Pipeline validation phase warnings.
Details
Sign in to post a comment.
Posted by Microsoft on 5/22/2013 at 5:08 PM
Hello Luca. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
PipelineWarnings.zip 5/21/2013 3 KB