using agreggate and a conditional split

David Rafael Segura Marques 1 Reputation point
2021-01-11T00:47:31.73+00:00

Hello All,

How can i pass though a certain column in an agreggate (this case "1nivel"). i want to use it only in the conditional split but there is no pass though in the aggregate. Does someone knows how to do this?

Best Regards,
David55115-fffff.png

SQL Server Integration Services
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,926 Reputation points
    2021-01-11T02:06:55.33+00:00

    Hi @David Rafael Segura Marques ,

    Only the selected columns in Aggregate can be passed to the next component.

    We can check the input columns and output columns in Advanced Editor in Aggregate.

    Then we can use the columns passed by Aggregate in Conditional Split.

    Please refer to the following pictures:
    55151-aggregate.png
    55099-advancedfora.png
    55142-conditionalsplit.png

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.