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.

Assign To

Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SSIS. The reasons for closing these bugs are following:1. The fix is risky to implement in the current version of the product2. Scenarios reported in the bug are not common enough3. A viable workaround is available.

If the issue is a critical business interruption, please call CSS (Customer Support Services).

Thanks again for reporting the product issue and continued support in improving our product.

Posted by Luca Zavarella on 7/22/2015 at 9:05 AM

Hi Walter,

any news on this issue?

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)