Unused output columns warning...

[victordba]

Hi,
I am getting a few of those warnings:
[DTS.Pipeline] Warning: The output column "ErrorCode" (1251) on output "Union All Output 1" (1214) and component "Union All" (1212) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

There are also similar warnings about other columns that I used at the beginning of the package, but didn't need them later on in the package.

How do I get rid of those warnings ? I don't really need those "ErrorCode" and "ErrorDescription" columns, but they are generated by a Lookup task and it's impossible to delete them.

Please, help.

Thanks,
Victor.

 

[MDXer]

Delete the columns from your union all. THe messages are simply warning and won't cause an issue in the execution of your packages. Since SSIS packages can be memory intense the recomendation is that you only carry columns and rows that you need for the whole process.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[victordba]

How do you delete the columns from the Union All task ???
It doesn't have an Advanced Editor to do that, and in a regular editor it's impossible.

 

[MDXer]

Right click on the column in question then click Delete.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[victordba]

Thanks, man.
I feel like poop now. Something so simple and I couldn't figure it out.

Thanks again,
Victor.

 

[MDXer]

Don't feel bad I accidently found it.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck