Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unused output columns warning...

Status
Not open for further replies.

victordba

Programmer
Jan 10, 2007
10
US
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.
 
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
 
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.
 
Right click on the column in question then click Delete.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Thanks, man.
I feel like poop now. Something so simple and I couldn't figure it out. :)

Thanks again,
Victor.
 
Don't feel bad I accidently found it.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top