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

Status : 

 


19
0
Sign in
to vote
ID 788331 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 5/21/2013 12:03:05 PM
Access Restriction Public

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.
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)