Remove pivot key column name from UNPIVOT as an outout column

  • Howdy,

    I've got an SSIS package that uses an UNPIVOT transformation and is working correctly.

    However the pivot key column name shows up in the log in a warning message. The message advises to remove the output column from the UNPIVOT component as it is not subsequently used in the data flow task.

    ...

    The output column "ColumnName" (3343) on output "Unpivot Output" (1512) and component "Unpivot" (1510) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

    ...

    I cannot figure out how to do that, I don't see a setting for that. I've also tried the Advanced Editor and don't see a setting for that. All I can do is delete the column entirely, which causes the transformation to not work.

    This is not causing the package to fail, but it does make it harder to find the actual error messages if there are any. I've got several UNPIVOT transformations in different dataflow tasks in this package so there is a lot of "false" warnings in the log.

    Any help is appreciated.

    ...thanks

  • Hi All,

    I am getting the same warning in my SSIS package. Any help is appreciated.

    Thanks,

    Balaji.

  • Sorry, I have not as yet found any workarounds for this.

  • Ok Thanks Rookie...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply